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)); }