Medicine Expiry Dates for a Wholesale Chemist - Live Project based Training in Advanced JAVA

Language

Database

IDE

Video on this Code

Framework Classes

Code Sample

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Medical_Managment_System
{
    public partial class Default : System.Web.UI.Page
    {
        private DataSet Getdisease()
        {
            using (SqlConnection con = new SqlConnection(CMedical.ConnString))
            {
                con.Open();
                using (SqlDataAdapter da =
                    new SqlDataAdapter("SELECT disease FROM tbldisease " +
                        " WHERE disease <> 'Cold'", con))
                {
                    DataSet ds = new DataSet();
                    da.Fill(ds);
                    return ds;
                }
            }
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DataSet ds = Getdisease();
                ddlDisease.DataSource = ds;
                ddlDisease.DataValueField = "disease";
                ddlDisease.DataBind();
            }

        }

        protected void cvMfDate_ServerValidate(object source, ServerValidateEventArgs args)
        {
            args.IsValid = calMfDate.SelectedDate > DateTime.Now;
        }

        protected void cvExDate_ServerValidate(object source, ServerValidateEventArgs args)
        {
            args.IsValid = calExDate.SelectedDate > DateTime.Now;
        }

        protected void lnkMedicine_Click(object sender, EventArgs e)
        {
            lblMessage.Text = "";
            if (Page.IsValid)
            {
                String strINSERTQuery = String.Format(
                    " INSERT INTO tblMedical(medicineName,mfDate,exDate,disease) " +
                    " VALUES('{0}','{1:dd-MMM-yyyy}','{1:dd-MMM-yyyy}','{3}')",
                    txtMedicineName.Text,
                    calMfDate.SelectedDate,
                    calExDate.SelectedDate,
                    ddlDisease.SelectedValue);
                using (SqlConnection con = new SqlConnection(CMedical.ConnString))
                {
                    con.Open();
                    using (SqlCommand cmd = con.CreateCommand())
                    {
                        cmd.CommandText = strINSERTQuery;
                        try
                        {
                            cmd.ExecuteNonQuery();
                            lblMessage.Text = "Data Saved!";

                        }
                        catch (System.Exception ex)
                        {
                            lblMessage.Text = "Operation Failed:" + ex.Message;
                            return;
                        }
                    }
                }
            }
        }
    }
}

Useful Links