public ActionResult SaveLcInfo(ImpLcInfo objLc, List<ImpLcDetails> objLcDetails)
{
var user = (User)Session["CurrentUser"];
objLc.UserId = user.EMPID;
objLc.TermId = user.TermID;
var res = _lcInfoRepository.SaveLcInfo(objLc, objLcDetails);
return Json(res, JsonRequestBehavior.AllowGet);
}
public ImpLcInfo SaveLcInfo(ImpLcInfo objLc, List <ImpLcDetails> objLcDetails)
{
var rv = new ImpLcInfo();
var res = CheckIsExist(objLc.LcId, objLc.LcNo);
if (!res)
{
//-------------------import LC Details information------------------------------------------
var lcDetailsDt = new DataTable();
lcDetailsDt.Columns.Add("ITEMCODE");
lcDetailsDt.Columns.Add("QNTY");
lcDetailsDt.Columns.Add("UNIT");
lcDetailsDt.Columns.Add("RATE");
lcDetailsDt.Columns.Add("AMOUNT");
lcDetailsDt.Columns.Add("CONVRATE");
lcDetailsDt.Columns.Add("VALUETAKA");
lcDetailsDt.Columns.Add("YARNCODE");
lcDetailsDt.Columns.Add("CURRENCYID");
lcDetailsDt.Columns.Add("USERID");
lcDetailsDt.Columns.Add("GROUPID");
if (objLcDetails != null && objLcDetails.Count > 0)
{
foreach (var order in objLcDetails)
{
DataRow row1;
row1 = lcDetailsDt.NewRow();
row1["ITEMCODE"] = order.ItemCode;
row1["QNTY"] = order.Qnty;
row1["RATE"] = order.Rate;
row1["UNIT"] = order.Unit;
row1["AMOUNT"] = order.Amount;
row1["CONVRATE"] = order.ConvRate;
row1["VALUETAKA"] = order.ValueTaka;
row1["YARNCODE"] = order.YarnCode;
row1["CURRENCYID"] = order.CurrencyId;
row1["USERID"] = order.UserId;
row1["GROUPID"] = order.GroupId;
lcDetailsDt.Rows.Add(row1);
}
}
lcDetailsDt.TableName = "tblLcDetails";
DataSet dsLcDetails = new DataSet("dsLcDetails");
dsLcDetails.Tables.Add(lcDetailsDt);
return(_lcInfoDataService.SaveLcInfo(objLc, dsLcDetails));
}
else
{
rv.SaveStatus = Operation.Exists.ToString();
return(rv);
}
}
public ImpLcInfo SaveLcInfo(ImpLcInfo objLc, DataSet dsLcDetails)
{
var res = new ImpLcInfo();
var dt = new DataTable();
try
{
dt = Insert_Update_OrderInfo("sp_insert_import_lc_info", "save_lc_info", objLc, dsLcDetails);
res.SaveStatus = Operation.Success.ToString();
res.LcId = Convert.ToInt32(dt.Rows[0]["LcId"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public DataTable Insert_Update_OrderInfo(string procedure, string callname, ImpLcInfo objLc, DataSet rqdXmlv1 = null)
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(procedure, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add("@dsxmlu1", SqlDbType.Xml).Value = (rqdXmlv1 == null ? null : rqdXmlv1.GetXml());
cmd.Parameters.Add(new SqlParameter("@p_LcId", objLc.LcId));
cmd.Parameters.Add(new SqlParameter("@p_SupplierId", objLc.SupplierId));
cmd.Parameters.Add(new SqlParameter("@p_LcNo", objLc.LcNo));
cmd.Parameters.Add(new SqlParameter("@p_LcDate", objLc.LcDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_BankId", objLc.BankId));
cmd.Parameters.Add(new SqlParameter("@p_BranchId", objLc.BranchId));
cmd.Parameters.Add(new SqlParameter("@p_ExpDate", objLc.ExpDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_ShipDate", objLc.ShipDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_SdExt", objLc.SdExt.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_PiNo", objLc.PiNo));
cmd.Parameters.Add(new SqlParameter("@p_PiDate", objLc.PiDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_InvoiceNo", objLc.InvoiceNo));
cmd.Parameters.Add(new SqlParameter("@p_InvDate", objLc.InvDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_IpNo", objLc.IpNo));
cmd.Parameters.Add(new SqlParameter("@p_IpDate", objLc.IpDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_Vassal", objLc.Vassal));
cmd.Parameters.Add(new SqlParameter("@p_Etd", objLc.Etd.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_Eta", objLc.Eta.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_ImpTypeId", objLc.ImpTypeId));
cmd.Parameters.Add(new SqlParameter("@p_StatusId", objLc.StatusId));
cmd.Parameters.Add(new SqlParameter("@p_UserId", objLc.UserId));
cmd.Parameters.Add(new SqlParameter("@p_TermId", objLc.TermId));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
