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;
}
