public PartialViewResult RawMaterialVendorPOView(string PO_No)
{
ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel();
objModel = objVPOAppData.GetOneVendorPurchaseOrder(PO_No);
return(PartialView(objModel));
}
public ssmtbl_VendorPurchaseOrderModel GetMaxPONo()
{
ssmtbl_VendorPurchaseOrderModel objPOModel = new ssmtbl_VendorPurchaseOrderModel();
try
{
string sqlstr = "select (Isnull(Max(po_id),0) + 1) as po_id from dbo.ssmtbl_VendorPurchaseOrder";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objPOModel.po_id = Convert.ToInt32(sdr["po_id"].ToString());
objPOModel.po_char = "VPO-" + StandardDateTime.GetDateTime().ToString("MMyy") + "-";
objPOModel.po_no = objPOModel.po_char + objPOModel.po_id;
objPOModel.quotation_ref_date = StandardDateTime.GetDateTime();
objPOModel.po_date = StandardDateTime.GetDateTime();
objPOModel.valid_date = StandardDateTime.GetDateTime();
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objPOModel);
}
public Paged_ssmtbl_VendorPurchaseOrderModel AllVPOFilter(string _inward_type)
{
Paged_ssmtbl_VendorPurchaseOrderModel objPGVPO = new Paged_ssmtbl_VendorPurchaseOrderModel();
List <ssmtbl_VendorPurchaseOrderModel> objList = new List <ssmtbl_VendorPurchaseOrderModel>();
try
{
string sqlstr = "VPORequisition";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "VPOBindFilter");
cmd.Parameters.AddWithValue("@inward_type", _inward_type.Trim());
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel();
objModel.auto_id = Convert.ToInt32(sdr["auto_id"].ToString());
objModel.vendor_name = sdr["Name"].ToString();
objModel.vendor_po_type = sdr["vendor_po_type"].ToString();
objModel.po_no = (sdr["po_no"].ToString());
objModel.po_date = Convert.ToDateTime(sdr["po_date"].ToString());
objList.Add(objModel);
}
connection.Close();
objPGVPO.ssmtbl_VendorPurchaseOrderModelList = objList;
// objPGVPO.vendor_po_type = vendor_po_type;
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objPGVPO);
}
public ssmtbl_VendorPurchaseOrderModel GetOneVendorPurchaseOrder(string po_no)
{
ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel();
try
{
//string sqlstr = "select auto_id, isnull(po_char,'') as po_char, isnull(po_id,0) as po_id, isnull(VPO.po_no,'') as po_no, "
//+ " isnull(quotation_ref_no,'') as quotation_ref_no, isnull(quotation_ref_date,'') as quotation_ref_date,"
//+ " isnull(vendor_id,0) as vendor_id, isnull(vendor_name,'') as vendor_name, isnull(vendor_email,'') as vendor_email, "
//+ " isnull(vendor_mobile,'') as vendor_mobile, isnull(contact_person_id,0) as contact_person_id,"
//+ " isnull(po_date,'') as po_date, isnull(valid_date,'') as valid_date, isnull(VPO.contact_person,'') as contact_person,"
//+ " isnull(contact_person_email,'') as contact_person_email, isnull(contact_person_mobile,'') as contact_person_mobile,"
//+ " isnull(vendor_po_type,'') as vendor_po_type, isnull(vendor_po_status,'') as vendor_po_status, isnull(Comment,'') as Comment,"
//+ " isnull(file_path,'') as file_path, isnull(total,0) as total, isnull(cgst_perc,0) as cgst_perc, isnull(cgst_amt,0) as cgst_amt,"
//+ " isnull(sgst_perc,0) as sgst_perc, isnull(sgst_amt,0) as sgst_amt, ISNULL(igst_perc,0) as igst_perc, isnull(igst_amt,0) as igst_amt,"
//+ " isnull(grand_total,0) as grand_total, isnull(CreatedBy,'') as CreatedBy, isnull(CreatedOn,'') as CreatedOn,"
//+ " isnull(UpdatedBy,'') as UpdatedBy, isnull(UpdatedOn,'') as UpdatedOn, isnull(ApprovalDate,'') as ApprovalDate,"
//+ " isnull(for_all_dia,'') as for_all_dia, isnull(dia_no,'') as dia_no,"
//+ " isnull(ApprovedBy,'') as ApprovedBy, Isnull(GSTIN,'') as GSTIN, Isnull(PAN,'') As PAN from ssmtbl_VendorPurchaseOrder VPO , "
//+ " CustomerVendorMaster_Tb CT where VPO.vendor_id=CT.Id and ISNULL(po_no,'')=@po_no";
//var connection = gConnection.Connection();
//connection.Open();
//SqlCommand cmd = new SqlCommand(sqlstr, connection);
//cmd.Parameters.AddWithValue("@po_no", po_no);
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "uspGetVendorPO";
SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "fetchVPOConsumableEditSingle");
cmd.Parameters.AddWithValue("@po_no", po_no.Trim());
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objModel.po_char = sdr["po_char"].ToString();
objModel.po_id = Convert.ToInt32(sdr["po_id"].ToString());
objModel.auto_id = Convert.ToInt32(sdr["auto_id"].ToString());
objModel.po_no = sdr["po_no"].ToString();
objModel.quotation_ref_no = sdr["quotation_ref_no"].ToString();
objModel.quotation_ref_date = Convert.ToDateTime(sdr["quotation_ref_date"]);
objModel.vendor_id = Convert.ToInt32(sdr["vendor_id"].ToString());
objModel.vendor_name = sdr["vendor_name"].ToString();
objModel.vendor_email = sdr["vendor_email"].ToString();
objModel.vendor_mobile = sdr["vendor_mobile"].ToString();
objModel.po_date = Convert.ToDateTime(sdr["po_date"]);
objModel.valid_date = Convert.ToDateTime(sdr["valid_date"]);
objModel.contact_person = sdr["contact_person"].ToString();
objModel.contact_person_id = Convert.ToInt32(sdr["contact_person_id"].ToString());
objModel.contact_person_email = sdr["contact_person_email"].ToString();
objModel.contact_person_mobile = sdr["contact_person_mobile"].ToString();
objModel.vendor_po_type = sdr["vendor_po_type"].ToString();
objModel.vendor_po_status = sdr["vendor_po_status"].ToString();
objModel.Comment = sdr["Comment"].ToString();
objModel.file_path = sdr["file_path"].ToString();
objModel.total = Convert.ToDecimal(sdr["total"].ToString());
objModel.cgst_perc = Convert.ToDecimal(sdr["cgst_perc"].ToString());
objModel.cgst_amt = Convert.ToDecimal(sdr["cgst_amt"].ToString());
objModel.sgst_perc = Convert.ToDecimal(sdr["sgst_perc"].ToString());
objModel.sgst_amt = Convert.ToDecimal(sdr["sgst_amt"].ToString());
objModel.igst_perc = Convert.ToDecimal(sdr["igst_perc"].ToString());
objModel.igst_amt = Convert.ToDecimal(sdr["igst_amt"].ToString());
objModel.grand_total = Convert.ToDecimal(sdr["grand_total"].ToString());
objModel.CreatedBy = sdr["CreatedBy"].ToString();
objModel.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"]);
objModel.UpdatedBy = sdr["UpdatedBy"].ToString();
objModel.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"]);
objModel.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"]);
objModel.ApprovedBy = sdr["ApprovedBy"].ToString();
objModel.for_all_dia = Convert.ToBoolean(sdr["for_all_dia"].ToString());
objModel.dia_no = sdr["dia_no"].ToString();
objModel.GSTIN = sdr["GSTIN"].ToString();
objModel.PAN = sdr["PAN"].ToString();
objModel.Address = sdr["Address"].ToString();
objModel.VersionNo = Convert.ToInt32(sdr["VersionNo"]);
}
sdr.Close();
connection.Close();
List <ssmtbl_VendorPurchaseOrder_DetailsModel> objVPO_DetList = new List <ssmtbl_VendorPurchaseOrder_DetailsModel>();
connection.Open();
string sqlstr1 = "uspGetVendorPO";
SqlCommand cmd1 = new SqlCommand(sqlstr1, GlobalVariables.gConn);
cmd1.CommandType = System.Data.CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Action", "fetchVPOConsumableEditMulti");
cmd1.Parameters.AddWithValue("@po_no", po_no.Trim());
SqlDataReader sdr1 = cmd1.ExecuteReader();
while (sdr1.Read())
{
ssmtbl_VendorPurchaseOrder_DetailsModel tempdata = new ssmtbl_VendorPurchaseOrder_DetailsModel();
tempdata.vpo_det_auto_id = Convert.ToInt32(sdr1["vpo_det_auto_id"].ToString());
tempdata.item_code = sdr1["item_code"].ToString();
tempdata.item_description = sdr1["item_description"].ToString();
tempdata.qty = Convert.ToDecimal(sdr1["qty"].ToString());
tempdata.rate = Convert.ToDecimal(sdr1["rate"].ToString());
tempdata.rate_per = sdr1["rate_per"].ToString();
tempdata.amount = Convert.ToDecimal(sdr1["amount"].ToString());
tempdata.rm_section = sdr1["rm_section"].ToString();
tempdata.rm_gradeofmaterial = sdr1["rm_gradeofmaterial"].ToString();
tempdata.process = sdr1["process"].ToString();
objVPO_DetList.Add(tempdata);
}
sdr1.Close();
objModel.ssmtbl_VendorPurchaseOrder_DetailsModel = objVPO_DetList;
connection.Close();
List <ssmtbl_TermsNCondtionModel> objVPO_TnCList = new List <ssmtbl_TermsNCondtionModel>();
connection.Open();
string sqlstr2 = "uspGetVendorPO";
SqlCommand cmd2 = new SqlCommand(sqlstr2, GlobalVariables.gConn);
cmd2.CommandType = System.Data.CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@Action", "fetchVPOConsumableEdittc");
cmd2.Parameters.AddWithValue("@po_no", po_no.Trim());
SqlDataReader sdr2 = cmd2.ExecuteReader();
while (sdr2.Read())
{
ssmtbl_TermsNCondtionModel tempdata = new ssmtbl_TermsNCondtionModel();
tempdata.id = Convert.ToInt32(sdr2["id"].ToString());
tempdata.TermsNConditionID = Convert.ToInt32(sdr2["TermsNConditionID"].ToString());
if (sdr2["po_no"].ToString() == "")
{
tempdata.TermsNConditionContent = sdr2["description"].ToString();
}
else
{
tempdata.TermsNConditionContent = sdr2["TermsNConditionContent"].ToString();
}
objVPO_TnCList.Add(tempdata);
}
objModel.ssmtbl_TermsNCondtionModel = objVPO_TnCList;
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objModel);
}
public List <ssmtbl_VendorPurchaseOrderModel> GetAllVendorPurchaseOrder(string vendor_po_status)
{
List <ssmtbl_VendorPurchaseOrderModel> objList = new List <ssmtbl_VendorPurchaseOrderModel>();
try
{
string sqlstr = "ssmsp_GetAllVendorPOForApproval";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vendor_po_status", vendor_po_status);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel();
objModel.auto_id = Convert.ToInt32(sdr["auto_id"].ToString());
objModel.po_no = sdr["po_no"].ToString();
objModel.quotation_ref_no = sdr["quotation_ref_no"].ToString();
objModel.quotation_ref_date = Convert.ToDateTime(sdr["quotation_ref_date"].ToString());
objModel.vendor_name = sdr["vendor_name"].ToString();
objModel.vendor_id = Convert.ToInt32(sdr["vendor_id"].ToString());
objModel.vendor_email = sdr["vendor_email"].ToString();
objModel.vendor_mobile = sdr["vendor_mobile"].ToString();
objModel.po_date = Convert.ToDateTime(sdr["po_date"].ToString());
objModel.valid_date = Convert.ToDateTime(sdr["valid_date"].ToString());
//objModel.contact_person = sdr["contact_person"].ToString();
objModel.contact_person_id = Convert.ToInt32(sdr["contact_person_id"].ToString());
objModel.contact_person_email = sdr["contact_person_email"].ToString();
objModel.contact_person_mobile = sdr["contact_person_mobile"].ToString();
objModel.vendor_po_type = sdr["vendor_po_type"].ToString();
objModel.vendor_po_status = sdr["vendor_po_status"].ToString();
objModel.Comment = sdr["Comment"].ToString();
objModel.file_path = sdr["file_path"].ToString();
objModel.total = Convert.ToDecimal(sdr["total"].ToString());
objModel.cgst_perc = Convert.ToDecimal(sdr["cgst_perc"].ToString());
objModel.cgst_amt = Convert.ToDecimal(sdr["cgst_amt"].ToString());
objModel.sgst_perc = Convert.ToDecimal(sdr["sgst_perc"].ToString());
objModel.sgst_amt = Convert.ToDecimal(sdr["sgst_amt"].ToString());
objModel.igst_perc = Convert.ToDecimal(sdr["igst_perc"].ToString());
objModel.igst_amt = Convert.ToDecimal(sdr["igst_amt"].ToString());
objModel.grand_total = Convert.ToDecimal(sdr["grand_total"].ToString());
objModel.CreatedBy = sdr["CreatedBy"].ToString();
objModel.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString());
objModel.UpdatedBy = sdr["UpdatedBy"].ToString();
objModel.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"].ToString());
objModel.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString());
objModel.ApprovedBy = sdr["ApprovedBy"].ToString();
objModel.for_all_dia = Convert.ToBoolean(sdr["for_all_dia"].ToString());
objModel.dia_no = sdr["dia_no"].ToString();
objList.Add(objModel);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objList);
}
public string UpdateVendorPurchaseOrder(ssmtbl_VendorPurchaseOrderModel model)
{
string result = "Error Creating Vendor Purchase Order";
try
{
model.ssmtbl_VendorPurchaseOrder_DetailsModel = NulltoBlank(model.ssmtbl_VendorPurchaseOrder_DetailsModel);
DataTable dt = new DataTable();
dt.Columns.Add("item_code");
dt.Columns.Add("item_description");
dt.Columns.Add("qty");
dt.Columns.Add("rate");
dt.Columns.Add("rate_per");
dt.Columns.Add("amount");
dt.Columns.Add("rm_section");
dt.Columns.Add("rm_gradeofmaterial");
dt.Columns.Add("process");
for (int i = 0; i < model.ssmtbl_VendorPurchaseOrder_DetailsModel.Count; i++)
{
dt.Rows.Add(model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].item_code,
model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].item_description,
model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].qty,
model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].rate,
model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].rate_per,
model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].amount,
model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].rm_section,
model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].rm_gradeofmaterial,
model.ssmtbl_VendorPurchaseOrder_DetailsModel[i].process);
}
DataTable dt1 = new DataTable();
dt1.Columns.Add("TermsNConditionID");
dt1.Columns.Add("TermsNConditionContent");
dt1.Columns.Add("flag");
for (int i = 0; i < model.ssmtbl_TermsNCondtionModel.Count; i++)
{
dt1.Rows.Add(model.ssmtbl_TermsNCondtionModel[i].TermsNConditionID,
model.ssmtbl_TermsNCondtionModel[i].TermsNConditionContent,
model.ssmtbl_TermsNCondtionModel[i].flag);
}
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmSP_Update_VendorPurchaseOrder";
SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@po_char", model.po_char);
cmd.Parameters.AddWithValue("@po_id", model.po_id);
cmd.Parameters.AddWithValue("@po_no", model.po_no);
cmd.Parameters.AddWithValue("@quotation_ref_no", model.quotation_ref_no);
cmd.Parameters.AddWithValue("@quotation_ref_date", model.quotation_ref_date);
cmd.Parameters.AddWithValue("@vendor_id", model.vendor_id);
cmd.Parameters.AddWithValue("@vendor_name", model.vendor_name);
cmd.Parameters.AddWithValue("@vendor_email", model.vendor_email);
cmd.Parameters.AddWithValue("@vendor_mobile", model.vendor_mobile);
cmd.Parameters.AddWithValue("@po_date", model.po_date);
cmd.Parameters.AddWithValue("@valid_date", model.valid_date);
cmd.Parameters.AddWithValue("@contact_person_id", model.contact_person_id);
cmd.Parameters.AddWithValue("@contact_person", model.contact_person);
cmd.Parameters.AddWithValue("@contact_person_email", model.contact_person_email);
cmd.Parameters.AddWithValue("@contact_person_mobile", model.contact_person_mobile);
cmd.Parameters.AddWithValue("@vendor_po_type", model.vendor_po_type);
cmd.Parameters.AddWithValue("@vendor_po_status", VendorPurchaseOrderStatus.VPOPendingForApproval);
cmd.Parameters.AddWithValue("@Comment", model.Comment);
cmd.Parameters.AddWithValue("@file_path", model.file_path);
cmd.Parameters.AddWithValue("@total", model.total);
cmd.Parameters.AddWithValue("@cgst_perc", model.cgst_perc);
cmd.Parameters.AddWithValue("@cgst_amt", model.cgst_amt);
cmd.Parameters.AddWithValue("@sgst_perc", model.sgst_perc);
cmd.Parameters.AddWithValue("@sgst_amt", model.sgst_amt);
cmd.Parameters.AddWithValue("@igst_perc", model.igst_perc);
cmd.Parameters.AddWithValue("@igst_amt", model.igst_amt);
cmd.Parameters.AddWithValue("@grand_total", model.grand_total);
cmd.Parameters.AddWithValue("@UpdatedBy", "Test");
cmd.Parameters.AddWithValue("@UpdatedOn", StandardDateTime.GetDateTime());
cmd.Parameters.AddWithValue("@for_all_dia", model.for_all_dia);
cmd.Parameters.AddWithValue("@dia_no", model.dia_no);
var pList = new SqlParameter("@ssmtbl_VendorPurchaseOrder_Details_", SqlDbType.Structured);
pList.TypeName = "dbo.ssmtbl_VendorPurchaseOrder_Details";
pList.Value = dt;
cmd.Parameters.Add(pList);
var pList1 = new SqlParameter("@ssmtbl_VendorPurchaseOrderTermsNCondtion_", SqlDbType.Structured);
pList1.TypeName = "dbo.ssmtbl_VendorPurchaseOrderTermsNCondtion";
pList1.Value = dt1;
cmd.Parameters.Add(pList1);
cmd.ExecuteNonQuery();
connection.Close();
result = "Vendor Purchase Order Created Successfully!";
}
catch (Exception ex)
{
Global.ErrorHandlerClass.LogError(ex);
}
return(result);
}
public Paged_ssmtbl_VendorPurchaseOrderModel AllVPOList(string _inward_type)
{
Paged_ssmtbl_VendorPurchaseOrderModel objPGVPO = new Paged_ssmtbl_VendorPurchaseOrderModel();
List <ssmtbl_VendorPurchaseOrderModel> objList = new List <ssmtbl_VendorPurchaseOrderModel>();
try
{
string sqlstr = "AllVPO";
var connection = gConnection.Connection();
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "selectApprovedVPO");
cmd.Parameters.AddWithValue("@vendor_po_type", _inward_type.Trim());
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_VendorPurchaseOrderModel objModel = new ssmtbl_VendorPurchaseOrderModel();
objModel.vpo_id = Convert.ToInt32(sdr["vpo_id"].ToString());
//objModel.cstpo_id= Convert.ToInt32(sdr["cstpo_id"].ToString());
//objModel.CustomerPONo = sdr["CustomerPONo"].ToString();
objModel.po_no = sdr["po_no"].ToString();
objModel.dia_no = sdr["dia_no"].ToString();
objModel.vendor_name = sdr["PartyName"].ToString();
objModel.customerName = sdr["PartyName"].ToString();
objModel.po_date = Convert.ToDateTime(sdr["po_date"].ToString());
//objModel.cstPODate = Convert.ToDateTime(sdr["cstPOcreateddate"].ToString());
objModel.PartyTYpe = sdr["PartyTYpe"].ToString();
objModel.vendor_po_type = sdr["Vtype"].ToString();
//objModel.quotation_ref_no = sdr["quotation_ref_no"].ToString();
//objModel.vendor_id = Convert.ToInt32(sdr["vendor_id"].ToString());
//objModel.quotation_ref_date = Convert.ToDateTime(sdr["quotation_ref_date"].ToString());
//objModel.vendor_email = sdr["vendor_email"].ToString();
//objModel.vendor_mobile = sdr["vendor_mobile"].ToString();
//objModel.valid_date = Convert.ToDateTime(sdr["valid_date"].ToString());
//objModel.contact_person = sdr["contact_person"].ToString();
//objModel.contact_person_email = sdr["contact_person_email"].ToString();
//objModel.contact_person_mobile = sdr["contact_person_mobile"].ToString();
//objModel.vendor_po_type = sdr["vendor_po_type"].ToString();
//objModel.vendor_po_status = sdr["vendor_po_status"].ToString();
//objModel.Comment = sdr["Comment"].ToString();
//objModel.file_path = sdr["file_path"].ToString();
//objModel.total = Convert.ToDecimal(sdr["total"].ToString());
//objModel.cgst_perc = Convert.ToDecimal(sdr["cgst_perc"].ToString());
//objModel.cgst_amt = Convert.ToDecimal(sdr["cgst_amt"].ToString());
//objModel.sgst_perc = Convert.ToDecimal(sdr["sgst_perc"].ToString());
//objModel.sgst_amt = Convert.ToDecimal(sdr["sgst_amt"].ToString());
//objModel.igst_perc = Convert.ToDecimal(sdr["igst_perc"].ToString());
//objModel.igst_amt = Convert.ToDecimal(sdr["igst_amt"].ToString());
//objModel.grand_total = Convert.ToDecimal(sdr["grand_total"].ToString());
//objModel.CreatedBy = sdr["CreatedBy"].ToString();
//objModel.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString());
//objModel.UpdatedBy = sdr["UpdatedBy"].ToString();
//objModel.UpdatedOn = Convert.ToDateTime(sdr["UpdatedOn"].ToString());
//objModel.ApprovalDate = Convert.ToDateTime(sdr["ApprovalDate"].ToString());
//objModel.ApprovedBy = sdr["ApprovedBy"].ToString();
objList.Add(objModel);
}
connection.Close();
objPGVPO.ssmtbl_GoodsInward_DocReceivedModel = objGFunc.GetGIDocReceivedList();
objPGVPO.ssmtbl_VendorPurchaseOrderModelList = objList;
// objPGVPO.vendor_po_type = vendor_po_type;
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objPGVPO);
}
