internal DataTable LoadItemUnit(UpdateItemMasterModel objUIMModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUIMModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUIMModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUIMModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUIMModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdItemMaster = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdItemMaster);
dtUpdItemMaster.TableName = "success";
}
catch (Exception)
{
dtUpdItemMaster = new DataTable();
dtUpdItemMaster.TableName = "error";
return(dtUpdItemMaster);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdItemMaster);
}
internal DataTable UpdateItem(UpdateItemMasterModel objUIMModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdateItems";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUIMModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUIMModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUIMModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUIMModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", objUIMModel.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@ItemName", objUIMModel.ItemName);
ClsCon.cmd.Parameters.AddWithValue("@ItemShortName", objUIMModel.ItemShortName);
ClsCon.cmd.Parameters.AddWithValue("@ItemUnitID", objUIMModel.ItemUnitID);
ClsCon.cmd.Parameters.AddWithValue("@GoodServiceInd", objUIMModel.GoodServiceInd);
ClsCon.cmd.Parameters.AddWithValue("@ItemSellingRate", objUIMModel.ItemSellingRate);
ClsCon.cmd.Parameters.AddWithValue("@ItemDescription", objUIMModel.ItemDesc);
ClsCon.cmd.Parameters.AddWithValue("@HSNSACCode", objUIMModel.HSNSACCode);
ClsCon.cmd.Parameters.AddWithValue("@TaxRate", objUIMModel.TaxRate);
ClsCon.cmd.Parameters.AddWithValue("@TaxRateType", objUIMModel.TaxRateDesc);
ClsCon.cmd.Parameters.AddWithValue("@ItemMinorUnitID", objUIMModel.ItemMinorUnitID);
ClsCon.cmd.Parameters.AddWithValue("@ItemMinorUnitQyt", objUIMModel.ItemMinorUnitQyt);
//ClsCon.cmd.Parameters.AddWithValue("@StockMaintainInd", objUIMModel.StockMaintainInd);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdItemMaster = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdItemMaster);
dtUpdItemMaster.TableName = "success";
}
catch (Exception)
{
dtUpdItemMaster = new DataTable();
dtUpdItemMaster.TableName = "error";
return(dtUpdItemMaster);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdItemMaster);
}
public DataSet ItemMasterDDL(UpdateItemMasterModel objUIMModel)
{
DataSet dsItemMaster = new DataSet();
objUIMModel.Ind = 1;
DataTable dtItems = objUIMDA.LoadItems(objUIMModel);
dtItems.TableName = "Items";
dsItemMaster.Tables.Add(dtItems);
objUIMModel.Ind = 2;
DataTable dtItemGroup = objUIMDA.LoadItemGroup(objUIMModel);
dtItemGroup.TableName = "ItemGroup";
dsItemMaster.Tables.Add(dtItemGroup);
objUIMModel.Ind = 14;
DataTable dtItemUnit = objUIMDA.LoadItemUnit(objUIMModel);
dtItemUnit.TableName = "ItemUnit";
dsItemMaster.Tables.Add(dtItemUnit);
objUIMModel.Ind = 2;
DataTable dtWarehouse = objUIMDA.LoadWarehouse(objUIMModel);
dtWarehouse.TableName = "Warehouse";
dsItemMaster.Tables.Add(dtWarehouse);
objUIMModel.Ind = 40;
DataTable dtTaxRate = objUIMDA.LoadTaxRate(objUIMModel); //objUIMDA.LoadTaxRate(objUIMModel);
dtTaxRate.TableName = "TaxRate";
dsItemMaster.Tables.Add(dtTaxRate);
return(dsItemMaster);
}
public DataTable UpdateItem(UpdateItemMasterModel objUIMModel)
{
DataTable dtSave = objUIMDA.UpdateItem(objUIMModel);
return(dtSave);
}
public DataTable LoadItemInfo(UpdateItemMasterModel objUIMModel)
{
DataTable dtItemInfo = objUIMDA.LoadItemInfo(objUIMModel);
return(dtItemInfo);
}
public DataTable LoadHSNSCDesc(UpdateItemMasterModel objUIMModel)
{
DataTable dtHSNSACDesc = objUIMDA.LoadHSNSCDesc(objUIMModel);
return(dtHSNSACDesc);
}
