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