} //end function public AllReligion AllReligionSelectByID(int intReligionID) { try { string sp_name = "AllReligionSelectByID"; comAllReligion.Parameters.AddWithValue("ReligionID", intReligionID); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsAllReligion.Tables[0].Rows.Count == 1) { DataRow drAllReligion = dsAllReligion.Tables[0].Rows[0]; AllReligion objAllReligion = new AllReligion(); objAllReligion.ReligionID = Convert.ToInt64(drAllReligion["ReligionID"]); objAllReligion.ReligionName = Convert.ToString(drAllReligion["ReligionName"]); objAllReligion.AddByID = Convert.ToInt64(drAllReligion["AddByID"]); objAllReligion.AddByDateTime = Convert.ToDateTime(drAllReligion["AddByDateTime"]); objAllReligion.LastUpDateByID = Convert.ToInt64(drAllReligion["LastUpDateByID"]); objAllReligion.LastUpdateDateTime = Convert.ToDateTime(drAllReligion["LastUpdateDateTime"]); objAllReligion.Remarks = Convert.ToString(drAllReligion["Remarks"]); objAllReligion.IsEnable = Convert.ToBoolean(drAllReligion["IsEnable"]); return(objAllReligion); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { AllReligionList.Clear(); foreach (DataRow drAllReligion in dsAllReligion.Tables[0].Rows) { AllReligion objAllReligion = new AllReligion(); objAllReligion.ReligionID = Convert.ToInt64(drAllReligion["ReligionID"]); objAllReligion.ReligionName = Convert.ToString(drAllReligion["ReligionName"]); objAllReligion.AddByID = Convert.ToInt64(drAllReligion["AddByID"]); objAllReligion.AddByDateTime = Convert.ToDateTime(drAllReligion["AddByDateTime"]); objAllReligion.LastUpDateByID = Convert.ToInt64(drAllReligion["LastUpDateByID"]); objAllReligion.LastUpdateDateTime = Convert.ToDateTime(drAllReligion["LastUpdateDateTime"]); objAllReligion.Remarks = Convert.ToString(drAllReligion["Remarks"]); objAllReligion.IsEnable = Convert.ToBoolean(drAllReligion["IsEnable"]); AllReligionList.Add(objAllReligion); } }
private void btnSave_Click(object sender, EventArgs e) { AllReligion religion = new AllReligion(); religion.ReligionID = 0; religion.ReligionName = txtReligion.Text; religion.AddByID = Convert.ToInt32(this.Tag); religion.AddByDateTime = System.DateTime.Now; religion.LastUpDateByID = Convert.ToInt32(this.Tag); religion.LastUpdateDateTime = System.DateTime.Now; religion.IsEnable = true; religion.Remarks = txtRemarks.Text; Int64 religion_Id = AllReligionController.InsertUpdateAllReligion(religion); if (religion_Id > 0) { SuccessMessage.SHowDialog("Religin Entered Successfully"); } else { ErrorMessage.SHowDialog("Religin not entered successfully"); } }
public static Int64 InsertUpdateAllReligion(AllReligion objIUAllReligion) { Int64 new_id = objIUAllReligion.InsertUpdateAllReligion(); return(new_id); }