public static int Save(Entity.SMS.DoctorMaster doctor)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pDoctorId", SqlDbType.Int, ParameterDirection.InputOutput, doctor.DoctorId);
oDm.Add("@pFullName", SqlDbType.VarChar, 100, doctor.FullName);
oDm.Add("@pGroupId", SqlDbType.Int, doctor.GroupId);
oDm.Add("@pMobileNo", SqlDbType.VarChar, 20, doctor.MobileNo);
oDm.Add("@pDistrictId", SqlDbType.Int, doctor.DistrictId);
oDm.Add("@pBlockId", SqlDbType.Int, doctor.BlockId);
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteNonQuery("usp_DoctorMaster_Save"));
}
}
protected void Populate()
{
BusinessLayer.SMS.DoctorMaster objdoc = new BusinessLayer.SMS.DoctorMaster();
Entity.SMS.DoctorMaster docEntity = new Entity.SMS.DoctorMaster();
docEntity = objdoc.GetById(DoctorId);
if (docEntity != null)
{
ddlGroup.SelectedValue = docEntity.GroupId.ToString();
ddlDistrict.SelectedValue = docEntity.DistrictId.ToString();
LoadBlock(Convert.ToInt32(ddlDistrict.SelectedValue));
ddlBlock.SelectedValue = docEntity.BlockId.ToString();
txtName.Text = docEntity.FullName.ToString();
txtMobileNo.Text = docEntity.MobileNo.ToString();
}
}
public static Entity.SMS.DoctorMaster GetById(int doctorId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pDoctorId", SqlDbType.Int, ParameterDirection.Input, doctorId);
SqlDataReader dr = oDm.ExecuteReader("usp_DoctorMaster_GetById");
Entity.SMS.DoctorMaster docEntity = new Entity.SMS.DoctorMaster();
if (dr.HasRows)
{
while (dr.Read())
{
docEntity.DoctorId = doctorId;
docEntity.FullName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
docEntity.GroupId = (dr[2] == DBNull.Value) ? 0 : Convert.ToInt32(dr[2].ToString());
docEntity.MobileNo = (dr[3] == DBNull.Value) ? "" : dr[3].ToString();
docEntity.DistrictId = (dr[4] == DBNull.Value) ? 0 : Convert.ToInt32(dr[4].ToString());
docEntity.BlockId = (dr[5] == DBNull.Value) ? 0 : Convert.ToInt32(dr[5].ToString());
}
}
return(docEntity);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
BusinessLayer.SMS.DoctorMaster objdoc = new BusinessLayer.SMS.DoctorMaster();
Entity.SMS.DoctorMaster docEntity = new Entity.SMS.DoctorMaster();
docEntity.DoctorId = DoctorId;
docEntity.GroupId = Convert.ToInt32(ddlGroup.SelectedValue);
docEntity.DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
docEntity.BlockId = Convert.ToInt32(ddlBlock.SelectedValue);
docEntity.FullName = txtName.Text.ToString();
docEntity.MobileNo = txtMobileNo.Text.ToString();
int RowAffected = objdoc.Save(docEntity);
if (RowAffected > 0)
{
ltrMsg.Text = "DATA SAVED SUCCESSFULLY !!";
ClearControls();
LoadDoctors();
}
else
{
ltrMsg.Text = "DUPLICATE DATA !!";
}
}
public int Save(Entity.SMS.DoctorMaster doctor)
{
return(DataAccess.SMS.DoctorMaster.Save(doctor));
}
