internal DataSet BindAll(BudgetSubSectionModel ObjBudgetSubSectionModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPBudgetSubSection"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjBudgetSubSectionModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjBudgetSubSectionModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjBudgetSubSectionModel.BrID); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dsBudgetSection = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dsBudgetSection); dsBudgetSection.DataSetName = "success"; } catch (Exception) { dsBudgetSection = new DataSet(); dsBudgetSection.DataSetName = "error"; return(dsBudgetSection); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dsBudgetSection); }
internal DataTable SaveBudgetSubSection(BudgetSubSectionModel ObjBudgetSubSectionModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPBudgetSubSection"; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjBudgetSubSectionModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjBudgetSubSectionModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjBudgetSubSectionModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@UserID", ObjBudgetSubSectionModel.User); ClsCon.cmd.Parameters.AddWithValue("@IPAddress", ObjBudgetSubSectionModel.IP); ClsCon.cmd.Parameters.AddWithValue("@SectionName", ObjBudgetSubSectionModel.SubSectionName); ClsCon.cmd.Parameters.AddWithValue("@SectionNameHindi", ObjBudgetSubSectionModel.SubSectionNameHindi); ClsCon.cmd.Parameters.AddWithValue("@ParentSectionID", ObjBudgetSubSectionModel.ParentSectionID); ClsCon.cmd.Parameters.AddWithValue("@SchemeCode", ObjBudgetSubSectionModel.SchemeCode); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtBudgetSection = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtBudgetSection); dtBudgetSection.TableName = "success"; } catch (Exception) { dtBudgetSection = new DataTable(); dtBudgetSection.TableName = "error"; return(dtBudgetSection); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtBudgetSection); }
private void BindAll() { try { objSubBudgetSection = new BudgetSubSectionModel(); objSubBudgetSection.Ind = 11; objSubBudgetSection.OrgID = GlobalSession.OrgID; objSubBudgetSection.BrID = GlobalSession.BrID; string uri = string.Format("BudgetSubSection/BindAll"); DataSet dsSubSection = CommonCls.ApiPostDataSet(uri, objSubBudgetSection); if (dsSubSection.Tables.Count > 0) { if (dsSubSection.Tables[1].Rows.Count > 0) { grdSubSection.DataSource = dsSubSection.Tables[1]; grdSubSection.DataBind(); //pnlSectionGrid.Visible = true; VSSubSection = dsSubSection.Tables[1]; lstSubSeaction.DataSource = dsSubSection.Tables[1]; lstSubSeaction.DataTextField = "SectionName"; lstSubSeaction.DataValueField = "SectionName"; lstSubSeaction.DataBind(); } if (dsSubSection.Tables[0].Rows.Count > 0) { ddlSection.DataSource = dsSubSection.Tables[0]; ddlSection.DataTextField = "SectionName"; ddlSection.DataValueField = "SectionID"; ddlSection.DataBind(); ddlSection.Items.Insert(0, new ListItem("-- Select --", "0")); VSSection = dsSubSection.Tables[0]; } } } catch (Exception ex) { ShowMessage(ex.Message, false); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (ddlSection.SelectedValue == "0") { ShowMessage("Select Group Name.", false); ddlSection.Focus(); return; } if (string.IsNullOrEmpty(txtSubSectionName.Text)) { ShowMessage("Enter Cost Centre Name.", false); txtSubSectionName.Focus(); return; } if (string.IsNullOrEmpty(txtSubSectionNameHindi.Text)) { ShowMessage("Enter Cost Centre Name(Hindi).", false); txtSubSectionNameHindi.Focus(); return; } objSubBudgetSection = new BudgetSubSectionModel(); objSubBudgetSection.OrgID = GlobalSession.OrgID; objSubBudgetSection.BrID = GlobalSession.BrID; objSubBudgetSection.User = GlobalSession.UserID; objSubBudgetSection.IP = GlobalSession.IP; objSubBudgetSection.SubSectionName = (txtSubSectionName.Text).ToUpper().Trim(); objSubBudgetSection.SubSectionNameHindi = (txtSubSectionNameHindi.Text).Trim(); objSubBudgetSection.ParentSectionID = CommonCls.ConvertIntZero(ddlSection.SelectedValue); objSubBudgetSection.SchemeCode = (txtSchemeCode.Text).Trim(); string uri; if (hfSectionID.Value == "0") { if (VSSubSection != null) { bool IsValid = CheckSectionNameExisting(); if (!IsValid) { return; } } objSubBudgetSection.Ind = 1;//For Saving Data uri = string.Format("BudgetSubSection/SaveBudgetSubSection"); } else { objSubBudgetSection.Ind = 2;//For Update Data objSubBudgetSection.SectionID = CommonCls.ConvertIntZero(hfSectionID.Value); uri = string.Format("BudgetSubSection/UpdateBudgetSubSection"); } DataTable dtSubSection = CommonCls.ApiPostDataTable(uri, objSubBudgetSection); if (dtSubSection.Rows.Count > 0) { ShowMessage("Record Save successfully.", true); hfSectionID.Value = "0"; BindAll(); ClearAll(); ddlSection_SelectedIndexChanged(sender, e); } else { ShowMessage("Record not Save successfully.", false); } } catch (Exception ex) { ShowMessage(ex.Message, false); } }
public DataTable DeleteBudgetSubSection(BudgetSubSectionModel ObjBudgetSubSectionModel) { DataTable SectionList = ObjBudgetSubSectionDA.DeleteBudgetSubSection(ObjBudgetSubSectionModel); return(SectionList); }
public DataSet BindAll(BudgetSubSectionModel ObjBudgetSubSectionModel) { DataSet SectionList = ObjBudgetSubSectionDA.BindAll(ObjBudgetSubSectionModel); return(SectionList); }