public void Filter_Get(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch) { int filteredCount = 0; List<FormEE> FormEE_List = new List<FormEE>(); DataTable dt = FormEE_DA.Filter_Get_FormEE(iDisplayLength, iDisplayStart, iSortCol_0, sSortDir_0, sSearch); foreach (DataRow row in dt.Rows) { filteredCount = int.Parse(row["TotalCount"].ToString()); FormEE _FormEE = new FormEE(); _FormEE.Id = int.Parse(row["Id"].ToString()); _FormEE.IsBLDate = Convert.ToBoolean(row["IsBLDate"].ToString()); _FormEE.BankCode = row["BankCode"].ToString(); _FormEE.SupplierInfoName = row["SupplierInfoName"].ToString(); _FormEE.InvoiceType = row["InvoiceType"].ToString(); if (row["From"].ToString() != "") _FormEE.FromString = Convert.ToDateTime(row["From"].ToString()).ToString("MM/dd/yyyy"); if (row["To"].ToString() != "") _FormEE.ToString = Convert.ToDateTime(row["To"].ToString()).ToString("MM/dd/yyyy"); FormEE_List.Add(_FormEE); } var result = new { iTotalRecords = GetTotalCount(), iTotalDisplayRecords = filteredCount, aaData = FormEE_List }; JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(result)); }
public static string SubmitFormEE(FormEE formEE) { DbCommand command = Catalog_Access.CreateCommand(); command.CommandText = "sp_SubmitFormEE"; DbParameter param; param = command.CreateParameter(); param.ParameterName = "@ID"; param.Value = formEE.Id; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@IsBLDate"; param.Value = formEE.IsBLDate; param.DbType = DbType.Boolean; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@BankId"; param.Value = formEE.BankId; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@From"; param.Value = formEE.From; param.DbType = DbType.Date; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@To"; param.Value = formEE.To; param.DbType = DbType.Date; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@SupplierInfoId"; param.Value = formEE.SupplierInfoId; param.DbType = DbType.Int32; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@InvoiceType"; param.Value = formEE.InvoiceType; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@User"; param.Value = formEE.User; param.DbType = DbType.String; command.Parameters.Add(param); param = command.CreateParameter(); param.ParameterName = "@Return"; param.DbType = DbType.String; param.Size = 50; param.Direction = ParameterDirection.Output; command.Parameters.Add(param); Catalog_Access.ExecuteNonQuery(command); string StatusOrId = command.Parameters["@Return"].Value.ToString(); return StatusOrId; }
public Tuple<FormEE, List<FormEE_B>> Get(int ID) { FormEE _FormEE = new FormEE(); DataTable dt = FormEE_DA.Get(ID); foreach (DataRow row in dt.Rows) { _FormEE.Id = int.Parse(row["Id"].ToString()); _FormEE.IsBLDate = Convert.ToBoolean(row["IsBLDate"].ToString()); if (row["BankId"].ToString() != "") _FormEE.BankId = int.Parse(row["BankId"].ToString()); if (row["From"].ToString() != "") _FormEE.FromString = Convert.ToDateTime(row["From"].ToString()).ToString("MM/dd/yyyy"); if (row["To"].ToString() != "") _FormEE.ToString = Convert.ToDateTime(row["To"].ToString()).ToString("MM/dd/yyyy"); if (row["SupplierInfoId"].ToString() != "") _FormEE.SupplierInfoId = int.Parse(row["SupplierInfoId"].ToString()); _FormEE.InvoiceType = row["InvoiceType"].ToString(); } List<FormEE_B> listFormEE_B = new List<FormEE_B>(); dt = FormEE_DA.Get_Collection(ID); foreach (DataRow row in dt.Rows) { FormEE_B _FormEE_B = new FormEE_B(); _FormEE_B.ID = int.Parse(row["ID"].ToString()); if (row["COMMERCIALINVOICEID"].ToString() != "") _FormEE_B.COMMERCIALINVOICEID = int.Parse(row["COMMERCIALINVOICEID"].ToString()); _FormEE_B.EXPORTFORMNO = row["EXPORTFORMNO"].ToString(); _FormEE_B.NAMEOFCONSIGNEE = row["NAMEOFCONSIGNEE"].ToString(); _FormEE_B.COMMODITY = row["COMMODITY"].ToString(); _FormEE_B.HSCODE = row["HSCODE"].ToString(); _FormEE_B.PINO = row["PINO"].ToString(); if (row["DATE"].ToString() != "") _FormEE_B.DATEstring = Convert.ToDateTime(row["DATE"].ToString()).ToString("MM/dd/yyyy"); _FormEE_B.CURRENCY = row["CURRENCY"].ToString(); if (row["AMOUNT"].ToString() != "") _FormEE_B.AMOUNT = float.Parse(row["AMOUNT"].ToString()); if (row["DATEOFSHIPMENT"].ToString() != "") _FormEE_B.DATEOFSHIPMENTstring = Convert.ToDateTime(row["DATEOFSHIPMENT"].ToString()).ToString("MM/dd/yyyy"); if (row["DATEOFNEGOTIATION"].ToString() != "") _FormEE_B.DATEOFNEGOTIATIONstring = Convert.ToDateTime(row["DATEOFNEGOTIATION"].ToString()).ToString("MM/dd/yyyy"); if (row["AMOUNTINFOREIGNEXCHANGE"].ToString() != "") _FormEE_B.AMOUNTINFOREIGNEXCHANGE = float.Parse(row["AMOUNTINFOREIGNEXCHANGE"].ToString()); if (row["EXCHANGERATEINRS"].ToString() != "") _FormEE_B.EXCHANGERATEINRS = float.Parse(row["EXCHANGERATEINRS"].ToString()); if (row["AMOUNTINPAKRUPEES"].ToString() != "") _FormEE_B.AMOUNTINPAKRUPEES = int.Parse(row["AMOUNTINPAKRUPEES"].ToString()); if (row["DATEOFREALIZATION"].ToString() != "") _FormEE_B.DATEOFREALIZATIONstring = Convert.ToDateTime(row["DATEOFREALIZATION"].ToString()).ToString("MM/dd/yyyy"); if (row["PAGENO"].ToString() != "") _FormEE_B.PAGENO = int.Parse(row["PAGENO"].ToString()); if (row["ITEMNO"].ToString() != "") _FormEE_B.ITEMNO = int.Parse(row["ITEMNO"].ToString()); _FormEE_B.SCHEDULE = row["SCHEDULE"].ToString(); _FormEE_B.REPORTINGMONTH = row["REPORTINGMONTH"].ToString(); _FormEE_B.BILLNEGOTIATED = row["BILLNEGOTIATED"].ToString(); _FormEE_B.REMARKS1 = row["REMARKS1"].ToString(); _FormEE_B.REMARKS2 = row["REMARKS2"].ToString(); listFormEE_B.Add(_FormEE_B); } return Tuple.Create(_FormEE, listFormEE_B); }
public static string Submit(FormEE formEE, List<FormEE_B> listFormEE_B) { string status = ""; if (formEE.Id == 0) { formEE.Id = int.Parse(SubmitFormEE(formEE)); if (formEE.Id > 0) { SubmitFormEE_B(listFormEE_B, formEE.Id, formEE.User); return "0"; } else return "1"; } else { status = SubmitFormEE(formEE); if (status == "4") { SubmitFormEE_B(listFormEE_B, formEE.Id, formEE.User); return "4"; } else return "1"; } }
public string Submit(FormEE formEE, List<FormEE_B> listFormEE_B) { string msg = ""; formEE.User = Session["User"].ToString(); msg = FormEE_DA.Submit(formEE, listFormEE_B); return msg; }