void fillSubGroup() { try { objplgroupType = new GroupTypeMasterModel(); objplgroupType.Ind = 3; objplgroupType.OrgID = GlobalSession.OrgID; objplgroupType.BrID = GlobalSession.BrID; objplgroupType.YrCD = GlobalSession.YrCD; string uri = string.Format("GroupTypeMaster/FillMainType"); DataTable GroupTypeSublist = CommonCls.ApiPostDataTable(uri, objplgroupType); if (GroupTypeSublist.Rows.Count > 0) { int mainGroupID = Convert.ToInt32(ddlMainGroup.SelectedValue); DataView dvsub = new DataView(GroupTypeSublist); dvsub.RowFilter = "GroupType = 2 AND ParentItemGroupID = " + mainGroupID + ""; ddlSubGroup.DataSource = dvsub; ddlSubGroup.DataTextField = "GroupName"; ddlSubGroup.DataValueField = "ItemGroupID"; ddlSubGroup.DataBind(); ddlSubGroup.Items.Insert(0, new ListItem("-- Select --", "0")); } } catch (Exception ex) { // ShowMessage(ex.Message, false); } }
void FillMaingroup() { try { objplgroupType = new GroupTypeMasterModel(); objplgroupType.Ind = 3; objplgroupType.OrgID = GlobalSession.OrgID; objplgroupType.YrCD = GlobalSession.YrCD; string uri = string.Format("GroupTypeMaster/FillMainType"); DataTable GroupTypeMainlist = CommonCls.ApiPostDataTable(uri, objplgroupType); if (GroupTypeMainlist.Rows.Count > 0) { DataView dv = new DataView(GroupTypeMainlist); dv.RowFilter = "GroupType = 1"; // query example = "id = 10" ddlMainGroup.DataSource = dv; ddlMainGroup.DataTextField = "GroupName"; ddlMainGroup.DataValueField = "ItemGroupId"; ddlMainGroup.DataBind(); ddlMainGroup.Items.Insert(0, new ListItem("-- Select --", "0")); } } catch (Exception ex) { // ShowMessage(ex.Message, false); } }
public DataTable SaveGroupItem(GroupTypeMasterModel ObjPlGroupTypeModel) { objGroupTypeDA = new GroupTypeMasterDataAcess(); DataTable SaveItem = objGroupTypeDA.SaveProcessGroupItem(ObjPlGroupTypeModel); return(SaveItem); }
public DataTable FillMainType(GroupTypeMasterModel ObjPlGroupTypeModel) { objGroupTypeDA = new GroupTypeMasterDataAcess(); DataTable fillVoucherType = objGroupTypeDA.FillMainGrpddl(ObjPlGroupTypeModel); return(fillVoucherType); }
internal DataTable SaveProcessGroupItem(GroupTypeMasterModel ObjPlGroupTypeModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPItemGroups"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPlGroupTypeModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPlGroupTypeModel.OrgID); // ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPlGroupTypeModel.BrID); // ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPlGroupTypeModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@GrType", ObjPlGroupTypeModel.GrType); ClsCon.cmd.Parameters.AddWithValue("@GrDesc", ObjPlGroupTypeModel.GrDesc); ClsCon.cmd.Parameters.AddWithValue("@ParentID", ObjPlGroupTypeModel.ParentID); ClsCon.cmd.Parameters.AddWithValue("@IP", ObjPlGroupTypeModel.IP); ClsCon.cmd.Parameters.AddWithValue("@User", ObjPlGroupTypeModel.User); // ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjWarehouseModel.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtGroupTypMaster = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtGroupTypMaster); dtGroupTypMaster.TableName = "success"; } catch (Exception) { dtGroupTypMaster = new DataTable(); dtGroupTypMaster.TableName = "error"; return(dtGroupTypMaster); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtGroupTypMaster); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (!CommonCls.CheckGUIDIsValid()) { return; } if (ddlGroupType.SelectedValue == "0") { ddlGroupType.Focus(); lblMsg.Text = "Select Group Type..!"; return; } if (ddlGroupType.SelectedValue == "2") { if (ddlMainGroup.SelectedValue == "0") { ddlMainGroup.Focus(); lblMsg.Text = "Select Main Group!"; return; } } else if (ddlGroupType.SelectedValue == "3") { if (ddlMainGroup.SelectedValue == "0") { ddlMainGroup.Focus(); lblMsg.Text = "Select Main Group!"; return; } if (ddlSubGroup.SelectedValue == "0") { lblMsg.Text = "Select Sub Group!"; return; } } if (string.IsNullOrEmpty(txtName.Text.Trim())) { txtName.Focus(); lblMsg.Text = "Enter Group Name..! "; return; } objplgroupType = new GroupTypeMasterModel(); objplgroupType.Ind = 1; objplgroupType.OrgID = GlobalSession.OrgID; objplgroupType.User = GlobalSession.UserID; objplgroupType.IP = GlobalSession.IP; objplgroupType.GrType = Convert.ToInt32(ddlGroupType.SelectedItem.Value); if (ddlGroupType.SelectedValue == "1") { objplgroupType.ParentID = 0; } else if (ddlGroupType.SelectedValue == "2") { objplgroupType.ParentID = Convert.ToInt32(ddlMainGroup.SelectedValue); } else if (ddlGroupType.SelectedValue == "3") { objplgroupType.ParentID = Convert.ToInt32(ddlSubGroup.SelectedValue); } //objplgroupType.ParentID = string.IsNullOrEmpty(ddlMainGroup.SelectedValue) ? 0 : ddlSubGroup.SelectedValue; //objplgroupType.ParentID = Convert.ToInt32(ddlMainGroup.SelectedValue == null ? "0" : ddlMainGroup.SelectedValue == null ? "0" : ddlSubGroup.SelectedValue); objplgroupType.GrDesc = txtName.Text; string uri = string.Format("GroupTypeMaster/SaveGroupItem"); DataTable GroupMasterSaveProcess = CommonCls.ApiPostDataTable(uri, objplgroupType); if (GroupMasterSaveProcess.Rows.Count > 0) { if (GroupMasterSaveProcess.Rows[0]["RecordID"].ToString() == "1") { lblMsg.Text = "Data Is SucessFully Saved..!"; } else if (GroupMasterSaveProcess.Rows[0]["RecordID"].ToString() == "2") { lblMsg.Text = "Data Already Added."; } } else { lblMsg.Text = "Data Is Not Saved..!"; } clear(); } catch (Exception ex) { } }