public ActionResult SaveMIssueInfo(MIssueInfo objMIssue, List <MIssueDetails> objMIssueDetails)
{
var user = (User)Session["CurrentUser"];
objMIssue.UserId = user.EMPID;
objMIssue.TermId = user.TermID;
var res = _issueRepository.SaveMIssueInfo(objMIssue, objMIssueDetails);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public MIssueInfo SaveMIssueInfo(MIssueInfo objMIssue, DataSet dsMIssueDetails)
{
var res = new MIssueInfo();
var dt = new DataTable();
try
{
dt = Insert_Update_MissueInfo("sp_insert_missue_info", "save_missue_info", objMIssue, dsMIssueDetails);
res.SaveStatus = Operation.Success.ToString();
res.IID = Convert.ToInt32(dt.Rows[0]["IID"].ToString());
}
catch (Exception ex)
{
res.SaveStatus = ex.Message;
}
return(res);
}
public DataTable Insert_Update_MissueInfo(string procedure, string callname, MIssueInfo objMIssue, 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_IID", objMIssue.IID));
cmd.Parameters.Add(new SqlParameter("@p_MIssueDate", objMIssue.IssueDate.ToString("dd-MMM-yyyy")));
cmd.Parameters.Add(new SqlParameter("@p_DepartmentId", objMIssue.DepartmentId));
cmd.Parameters.Add(new SqlParameter("@p_SRNo", objMIssue.SRNo));
cmd.Parameters.Add(new SqlParameter("@p_CompanyId", objMIssue.CompanyId));
cmd.Parameters.Add(new SqlParameter("@p_UnitCode", objMIssue.UnitCode));
cmd.Parameters.Add(new SqlParameter("@p_TypeFlag", objMIssue.TypeFlag));
cmd.Parameters.Add(new SqlParameter("@p_UserId", objMIssue.UserId));
cmd.Parameters.Add(new SqlParameter("@p_TermId", objMIssue.TermId));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public MIssueInfo SaveMIssueInfo(MIssueInfo objMIssue, List <MIssueDetails> objMIssueDetails)
{
var rv = new MIssueInfo();
//-------------------MIssue Details information------------------------------------------
var miDetailsDt = new DataTable();
miDetailsDt.Columns.Add("ICODE");
miDetailsDt.Columns.Add("QNTY");
miDetailsDt.Columns.Add("RATE");
miDetailsDt.Columns.Add("VALUE");
miDetailsDt.Columns.Add("UNIT");
miDetailsDt.Columns.Add("CURCODE");
miDetailsDt.Columns.Add("RATETAKA");
miDetailsDt.Columns.Add("VALUETAKA");
miDetailsDt.Columns.Add("SETNO");
miDetailsDt.Columns.Add("LCNO");
miDetailsDt.Columns.Add("INVNO");
miDetailsDt.Columns.Add("LCODE");
miDetailsDt.Columns.Add("SCODE");
miDetailsDt.Columns.Add("LOTNO");
miDetailsDt.Columns.Add("IMPTYPEID");
miDetailsDt.Columns.Add("PTGL");
miDetailsDt.Columns.Add("USERNAME");
miDetailsDt.Columns.Add("REMARKS");
miDetailsDt.Columns.Add("AUTOLOT");
miDetailsDt.Columns.Add("YARNCODE");
miDetailsDt.Columns.Add("GCODE");
miDetailsDt.Columns.Add("COTTONTYPEID");
if (objMIssueDetails != null && objMIssueDetails.Count > 0)
{
foreach (var mid in objMIssueDetails)
{
var row1 = miDetailsDt.NewRow();
row1["ICODE"] = mid.ICode;
row1["QNTY"] = mid.Qnty;
row1["RATE"] = mid.Rate;
row1["VALUE"] = mid.Value;
row1["UNIT"] = mid.Unit;
row1["CURCODE"] = mid.CurCode;
row1["RATETAKA"] = mid.RateTaka;
row1["VALUETAKA"] = mid.ValueTaka;
row1["SETNO"] = mid.SetNo;
row1["LCNO"] = mid.LCNo;
row1["INVNO"] = mid.InvNo;
row1["LCODE"] = mid.LCode;
row1["SCODE"] = mid.SCode;
row1["LOTNO"] = mid.LotNo;
row1["IMPTYPEID"] = mid.ImpTypeId;
row1["PTGL"] = mid.PTGL;//n
row1["USERNAME"] = objMIssue.UserId;
row1["REMARKS"] = mid.Remarks;
row1["AUTOLOT"] = mid.AutoLot;
row1["YARNCODE"] = mid.YarnCode;
row1["GCODE"] = mid.GCode;
row1["COTTONTYPEID"] = mid.CottonTypeId;
miDetailsDt.Rows.Add(row1);
}
}
miDetailsDt.TableName = "tblMIssueDetails";
DataSet dsMIssueDetails = new DataSet("dsMIssueDetails");
dsMIssueDetails.Tables.Add(miDetailsDt);
return(_mIssueDataService.SaveMIssueInfo(objMIssue, dsMIssueDetails));
}
