void FillItemName()
{
objplOpenStock = new ItemOpenningStockModel()
{
Ind = 30,
OrgID = GlobalSession.OrgID,
BrID = GlobalSession.BrID,
YrCD = GlobalSession.YrCD,
};
string uri = string.Format("ItemOpenStock/FillItemName");
DataTable dtItemName = CommonCls.ApiPostDataTable(uri, objplOpenStock);
if (dtItemName.Rows.Count > 0)
{
ddlItemName.DataSource = ViewState["ItemNameList"] = dtItemName;
ddlItemName.DataTextField = "ItemName";
ddlItemName.DataValueField = "ItemID";
ddlItemName.DataBind();
ddlItemName.Items.Insert(0, new ListItem {
Text = "-Select-", Value = "0"
});
ddlItemName.SelectedIndex = 0;
}
}
void FillWareHouse()
{
objplOpenStock = new ItemOpenningStockModel()
{
Ind = 2,
OrgID = GlobalSession.OrgID,
BrID = GlobalSession.BrID,
YrCD = GlobalSession.YrCD,
};
string uri = string.Format("ItemOpenStock/FillWareHouse");
DataTable dtWareHouse = CommonCls.ApiPostDataTable(uri, objplOpenStock);
if (dtWareHouse.Rows.Count > 0)
{
ddlwarehouse.DataSource = dtWareHouse;
ddlwarehouse.DataTextField = "WareHouseAddress";
ddlwarehouse.DataValueField = "WareHouseID";
ddlwarehouse.DataBind();
ddlwarehouse.Items.Insert(0, new ListItem {
Text = "-Select-", Value = "0"
});
ddlwarehouse.SelectedIndex = 0;
}
}
void FillUnitName()
{
objplOpenStock = new ItemOpenningStockModel()
{
OrgID = GlobalSession.OrgID,
BrID = GlobalSession.BrID,
YrCD = GlobalSession.YrCD,
};
string uri = string.Format("ItemOpenStock/FillUnit");
DataSet dsItemUnit = CommonCls.ApiPostDataSet(uri, objplOpenStock);
if (dsItemUnit.Tables.Count > 0)
{
DataTable dtPrimaryUnit = dsItemUnit.Tables[0];
DataTable dtSecondryUnit = dsItemUnit.Tables[0];
ddlPriUnit.DataSource = dtPrimaryUnit;
ddlPriUnit.DataTextField = "UnitName";
ddlPriUnit.DataValueField = "UnitID";
ddlPriUnit.DataBind();
ddlPriUnit.Items.Insert(0, new ListItem("-- Select --", "0"));
ddlsecunit.DataSource = dtSecondryUnit;
ddlsecunit.DataTextField = "UnitName";
ddlsecunit.DataValueField = "UnitID";
ddlsecunit.DataBind();
ddlsecunit.Items.Insert(0, new ListItem("-- Select --", "0"));
}
}
public DataSet FillUnit(ItemOpenningStockModel ObjopenStockModel)
{
ObjopenStockModel.Ind = 14;
DataSet DSFillUnit = objOpenStockDA.FillUnit(ObjopenStockModel);
//DSFillUnit.Tables[0].TableName = "PrimaryUnit";
//DSFillUnit.Tables[1].TableName = "SecondryUnit";
return(DSFillUnit);
}
void fillGrid()
{
objplOpenStock = new ItemOpenningStockModel()
{
Ind = 32,
OrgID = GlobalSession.OrgID,
BrID = GlobalSession.BrID,
YrCD = GlobalSession.YrCD,
ItemID = Convert.ToInt32(ddlItemName.SelectedValue),
};
string uri = string.Format("ItemOpenStock/FillGridItem");
DataTable FillGridItemName = CommonCls.ApiPostDataTable(uri, objplOpenStock);
if (FillGridItemName.Rows.Count > 0)
{
//grdOpenStockEntry.DataSource = FillGridItemName;
//grdOpenStockEntry.DataBind();
FillGridItemName.Columns["CompanyID"].SetOrdinal(0);
FillGridItemName.Columns["WareHouseID"].SetOrdinal(1);
FillGridItemName.Columns["Address"].SetOrdinal(2);
FillGridItemName.Columns["ItemUnitID"].SetOrdinal(3);
FillGridItemName.Columns["ItemOpeningQty"].SetOrdinal(4);
FillGridItemName.Columns["ItemMinorUnitID"].SetOrdinal(5);
FillGridItemName.Columns["ItemMinorUnitQty"].SetOrdinal(6);
FillGridItemName.Columns["ItemOpeningRate"].SetOrdinal(7);
FillGridItemName.Columns["ItemOpeningDate"].SetOrdinal(8);
if (FillGridItemName.Columns.Contains("ItemOpeningRate1"))
{
FillGridItemName.Columns.Remove("ItemOpeningRate1");
}
if (FillGridItemName.Columns.Contains("UnitName"))
{
FillGridItemName.Columns.Remove("UnitName");
}
foreach (DataRow item in FillGridItemName.Rows)
{
item["ItemOpeningDate"] = CommonCls.ConvertToDate(item["ItemOpeningDate"].ToString());
}
gridOpenStock.DataSource = VsDtOpenStock = FillGridItemName;
gridOpenStock.DataBind();
}
else
{
gridOpenStock.DataSource = null;
gridOpenStock.DataBind();
//grdOpenStockEntry.DataSource = null;
//grdOpenStockEntry.DataBind();
}
}
internal DataTable SaveEntry(ItemOpenningStockModel ObjopenStockModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjopenStockModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjopenStockModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjopenStockModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", ObjopenStockModel.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@User", ObjopenStockModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", ObjopenStockModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@TblItemOpening", ObjopenStockModel.DtItem);
// ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjopenStockModel.BrID);
//ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjopenStockModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtopenStock = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtopenStock);
dtopenStock.TableName = "success";
}
catch (Exception)
{
dtopenStock = new DataTable();
dtopenStock.TableName = "error";
return(dtopenStock);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtopenStock);
}
internal DataSet FillUnit(ItemOpenningStockModel ObjopenStockModel) //fill GistnNo
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@DataInd", ObjopenStockModel.Ind);
//ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjopenStockModel.OrgID);
//ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjopenStockModel.BrID);
//ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjopenStockModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
DsOpenStock = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(DsOpenStock);
// DsOpenStock.TableName = "success";
}
catch (Exception)
{
DsOpenStock = new DataSet();
// dtopenStock.TableName = "error";
return(DsOpenStock);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(DsOpenStock);
}
public DataTable SaveStockEntry(ItemOpenningStockModel ObjopenStockModel)
{
DataTable dtSaveProcess = objOpenStockDA.SaveEntry(ObjopenStockModel);
return(dtSaveProcess);
}
public DataTable FillGridItem(ItemOpenningStockModel ObjopenStockModel)
{
DataTable dtFillGridItem = objOpenStockDA.FillGridItemName(ObjopenStockModel);
return(dtFillGridItem);
}
public DataTable FillWareHouse(ItemOpenningStockModel ObjopenStockModel)
{
DataTable dtFillWareHouse = objOpenStockDA.FillIWareHouseName(ObjopenStockModel);
return(dtFillWareHouse);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!CommonCls.CheckGUIDIsValid())
{
return;
}
objplOpenStock = new ItemOpenningStockModel();
if (CommonCls.ConvertIntZero(ddlItemName.SelectedValue) == 0)
{
ddlItemName.Focus();
ShowMessage("Fill Item Detail..", false);
return;
}
if (gridOpenStock.Rows.Count > 0)
{
objplOpenStock.Ind = 31;
objplOpenStock.OrgID = GlobalSession.OrgID;
objplOpenStock.YrCD = GlobalSession.YrCD;
objplOpenStock.User = GlobalSession.UserID;
objplOpenStock.IP = GlobalSession.IP;
objplOpenStock.ItemID = Convert.ToInt32(ddlItemName.SelectedValue);
objplOpenStock.DtItem = VsDtOpenStock;
if (objplOpenStock.DtItem.Columns.Contains("ItemID"))
{
objplOpenStock.DtItem.Columns.Remove("ItemID");
}
//if (objplOpenStock.DtItem.Columns.Contains("WareHouseName"))
//{
// objplOpenStock.DtItem.Columns.Remove("WareHouseName");
//}
if (objplOpenStock.DtItem.Columns.Contains("Address"))
{
objplOpenStock.DtItem.Columns.Remove("Address");
}
string uri = string.Format("ItemOpenStock/SaveStockEntry");
DataTable dtSaveopenStockEntry = CommonCls.ApiPostDataTable(uri, objplOpenStock);
if (dtSaveopenStockEntry.Rows.Count > 0)
{
ShowMessage("Data Is SucessFully Saved..", true);
ClearAfterSaved();
VsDtOpenStock = null;
// fillGrid();
}
else
{
ShowMessage("Data Is Not Saved..", false);
}
}
else
{
ShowMessage("Fill All Item Detail..", false);
}
fillGrid();
}
catch (Exception ex)
{
ShowMessage(ex.Message, false);
}
}
