public loginResponse FileCancel(SavePresentmentDetails ul)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ul.AppID].ConnectionString);
string query = ""; SqlCommand dbcommand;
loginResponse res = new loginResponse();
if (ul.AppID == null || ul.AppID.Trim() == "")
{
res.ResDescription = "Invalid AppId";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30008";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.AppID.Trim() != "" && ValidatePresement.ValidateAppID(ul.AppID.Trim()) != true)
{
res.ResDescription = "Invalid AppId";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30008";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ValidatePresement.CheckAccess(ul.AppID.Trim(), "P") != true)
{
res.ResDescription = "Unauthorized user";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30017";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.MerchantKey == null || ul.MerchantKey.Trim() == "")
{
res.ResDescription = "Invalid MerchantKey";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30009";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.MerchantKey.Trim() != "" && ValidatePresement.ValidateEntityMerchantKey(ul.MerchantKey.Trim(), ul.AppID) != true)
{
res.ResDescription = "Invalid MerchantKey";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30009";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.ActivityID == null || ul.ActivityID.Trim() == "")
{
res.ResDescription = "Invalid ActivityId";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30010";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
//else if (ul.ActivityID.Trim() != "")
//{
// int checklength = ul.ActivityID.Length;
// if (checklength != 18)
// {
// res.ResDescription = "Invalid ActivityId";
// res.Status = "Failure";
// res.ActivityID = ul.ActivityID;
// res.ResCode = "ykR30010";
// res.FileNo = "";
// res.BankCode = ul.BankCode;
// res.CreatedDateTime = "";
// res.LastEditDateTime = "";
// res.TotalRecords = "";
// res.TotalAmt = "";
// res.FileStatus = "";
// res.UMRNData = ul.UMRNData;
// return res;
// }
//}
if (ul.RequestType == null || ul.RequestType.Trim() == "")
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.FileNo == null || ul.FileNo.Trim() == "")
{
res.ResDescription = "Invalid File Number";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30011";
res.FileNo = ul.FileNo;
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else
{
bool Flag = true;
#region For Checking Activity
try
{
if (ul.ActivityID.Trim() != "")
{
query = "Sp_PresentMentWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "ValidateActivity");
dbcommand.Parameters.AddWithValue("@ActivityId", ul.ActivityID);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
int getactivity = Convert.ToInt32(ds.Tables[0].Rows.Count);
if (getactivity == 0)
{
dbcommand.Connection.Close(); dbcommand.Parameters.Clear();
res.ResDescription = "Invalid ActivityId";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30010";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
}
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
}
#endregion
#region For Checking File Number
try
{
if (ul.FileNo.Trim() != "")
{
conn.Close();
query = "Sp_PresentMentWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "ValidateFileno");
dbcommand.Parameters.AddWithValue("@FileNumber", ul.FileNo);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
int getactivity = Convert.ToInt32(ds.Tables[0].Rows.Count);
if (getactivity == 0)
{
dbcommand.Connection.Close(); dbcommand.Parameters.Clear();
res.ResDescription = "Invalid File Number";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30011";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
}
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
}
#endregion
#region Check integer compare
if (ul.RequestType.Trim() != "")
{
if (ul.RequestType == "2")
{
bool checkrequesttype = ValidatePresement.ValidateInteger(ul.RequestType);
if (checkrequesttype == true)
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
}
else
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
}
#endregion
#region Check File integer compare
if (ul.FileNo.Trim() != "")
{
bool checkfileno = ValidatePresement.ValidateInteger(ul.FileNo);
if (checkfileno == true)
{
res.ResDescription = "Invalid File Number";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30011";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
}
#endregion
if (Flag)
{
#region Insert Presentment Header
try
{
conn.Close();
query = "Sp_PresentMentWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UPDATEPRESENTMENTFILE");
dbcommand.Parameters.AddWithValue("@FileNumber", Convert.ToString(ul.FileNo.Trim()));
dbcommand.Parameters.AddWithValue("@AppId", Convert.ToInt64(ul.AppID.Trim()));
dbcommand.Parameters.AddWithValue("@ActivityId", ul.ActivityID.Trim());
dbcommand.Parameters.AddWithValue("@RequestType", Convert.ToInt64(ul.RequestType.Trim()));
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
res.ActivityID = ds.Tables[1].Rows[0]["ActivityId"].ToString();
res.FileNo = ds.Tables[1].Rows[0]["FileNo"].ToString();
res.BankCode = ds.Tables[1].Rows[0]["BankCode"].ToString();
res.CreatedDateTime = Convert.ToDateTime(ds.Tables[1].Rows[0]["CreatedDateTime"].ToString()).ToString("yyyy-MM-dd hh:mm");
res.LastEditDateTime = Convert.ToDateTime(ds.Tables[1].Rows[0]["LastEditDateTime"].ToString()).ToString("yyyy-MM-dd hh:mm");
res.TotalRecords = ds.Tables[0].Rows[0]["Recordcount"].ToString();
res.TotalAmt = ds.Tables[0].Rows[0]["TotalAmount"].ToString();
res.Status = "Success";
res.FileStatus = ds.Tables[1].Rows[0]["FileStatus"].ToString();
res.ResCode = "ykR30002";
res.ResDescription = "Cancelled Successfully";
string GenerateXML = ""; string UMRN = ""; string AMOUNT = "";
string finalxml = "<UMDATA>";
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
UMRN = ds.Tables[2].Rows[i]["UMRN"].ToString();
AMOUNT = ds.Tables[2].Rows[i]["AMOUNT"].ToString();
GenerateXML = ValidatePresement.XMLCREATION(UMRN, AMOUNT, Convert.ToDateTime(ds.Tables[1].Rows[0]["LastEditDateTime"].ToString()).ToString("yyyy-MM-dd hh:mm"), ds.Tables[1].Rows[0]["FileStatus"].ToString());
finalxml += GenerateXML;
}
finalxml += "</UMDATA>";
res.UMRNData = finalxml;
return(res);
}
else
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
}
#endregion
}
else
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
}
return(res);
}
public loginResponse PresentmentFile(SavePresentmentDetails ul)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ul.AppID].ConnectionString);
string query = ""; SqlCommand dbcommand;
loginResponse res = new loginResponse();
if (ul.AppID == null || ul.AppID.Trim() == "")
{
res.ResDescription = "Invalid AppId";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30008";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.AppID.Trim() != "" && ValidatePresement.ValidateAppID(ul.AppID.Trim()) != true)
{
res.ResDescription = "Invalid AppId";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30008";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ValidatePresement.CheckAccess(ul.AppID.Trim(), "P") != true)
{
res.ResDescription = "Unauthorized user";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30017";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.MerchantKey == null || ul.MerchantKey.Trim() == "")
{
res.ResDescription = "Invalid Merchant Key";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30009";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.MerchantKey.Trim() != "" && ValidatePresement.ValidateEntityMerchantKey(ul.MerchantKey.Trim(), ul.AppID) != true)
{
res.ResDescription = "Invalid Merchant Key";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30009";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.ActivityID == null || ul.ActivityID.Trim() == "")
{
res.ResDescription = "Invalid ActivityId";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30010";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
//else if (ul.ActivityID.Trim() != "")
//{
// int checklength = ul.ActivityID.Length;
// if(checklength !=18)
// {
// res.ResDescription = "Invalid ActivityId";
// res.Status = "Failure";
// res.ActivityID = ul.ActivityID;
// res.ResCode = "ykR30010";
// res.FileNo = "";
// res.BankCode = ul.BankCode;
// res.CreatedDateTime = "";
// res.LastEditDateTime = "";
// res.TotalRecords = "";
// res.TotalAmt = "";
// res.FileStatus = "";
// res.UMRNData = ul.UMRNData;
// return res;
// }
//}
if (ul.BankCode == null || ul.BankCode.Trim() == "")
{
res.ResDescription = "Invalid Bank";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30014";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.PresentmentDate == null || ul.PresentmentDate.Trim() == "")
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.RequestType == null || ul.RequestType.Trim() == "")
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else if (ul.UMRNData == null || ul.UMRNData.Trim() == "")
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
else
{
bool Flag = true;
#region For Checking Activity
try
{
conn.Close();
if (ul.ActivityID.Trim() != "")
{
query = "Sp_PresentMentWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "ValidateActivity");
dbcommand.Parameters.AddWithValue("@ActivityId", ul.ActivityID);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
int getactivity = Convert.ToInt32(ds.Tables[0].Rows.Count);
if (getactivity != 0)
{
dbcommand.Connection.Close(); dbcommand.Parameters.Clear();
res.ResDescription = "ActivityId is already exist";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30016";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
}
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
}
#endregion
#region Check integer compare
if (ul.RequestType.Trim() != "")
{
if (ul.RequestType == "1")
{
bool checkrequesttype = ValidatePresement.ValidateInteger(ul.RequestType);
if (checkrequesttype == true)
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
}
else
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
}
#endregion
#region For Checking Bank
try
{
if (ul.BankCode.Trim() != "")
{
conn.Close();
query = "Sp_PresentMentWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "ValidateBank");
dbcommand.Parameters.AddWithValue("@Bankcode", ul.BankCode);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
int getbankcount = Convert.ToInt32(ds.Tables[0].Rows.Count);
if (getbankcount == 0)
{
dbcommand.Connection.Close(); dbcommand.Parameters.Clear();
res.ResDescription = "Invalid Bank";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30014";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
}
else
{
dbcommand.Connection.Close(); dbcommand.Parameters.Clear();
res.ResDescription = "Invalid Bank";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30014";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
}
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
}
#endregion
#region Checking Duplicate XML
int getcount = ValidatePresement.CheckXMLDUPLICATE(ul.UMRNData);
if (getcount == 1)
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
#endregion
#region Checking Numeric or decimal Amount in XML
bool checkamt = ValidatePresement.CheckXMLDUPLICATEAMOUNT(ul.UMRNData);
if (checkamt == true)
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
#endregion
#region Checking Valid Date
bool validdate = ValidatePresement.ValidateDate(ul.PresentmentDate);
if (validdate == true)
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
#endregion
#region Checking Valid Date
if (ValidatePresement.ValidateDate(ul.PresentmentDate, ul.AppID, ul.PresentmentDate, ul.BankCode))
{
res.ResDescription = "Unauthorized request";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30017";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
#endregion
#region Checking Valid Date
if (ValidatePresement.ValidateEntityDate(ul.PresentmentDate, ul.AppID, ul.PresentmentDate, ul.BankCode) == "2")
{
res.ResDescription = "Unauthorized request";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30017";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
Flag = false;
return(res);
}
#endregion
if (Flag)
{
string xml = ul.UMRNData;
string createsinglexml = ValidatePresement.CreateXML(xml);
string val = "";
Random generator = new Random();
Int64 r = generator.Next(000000000, 999999999);
Random generator1 = new Random();
Int64 r1 = generator1.Next(000000000, 999999999);
val += r.ToString() + r1.ToString();
Int64 filenumber = Convert.ToInt64(val);
#region Insert Presentment Header
try
{
conn.Close();
query = "Sp_PresentMentWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "INSERTPRESENTMENTFILE");
dbcommand.Parameters.AddWithValue("@FileNumber", Convert.ToString(filenumber));
dbcommand.Parameters.AddWithValue("@PresentmentDate", ul.PresentmentDate.Trim());
dbcommand.Parameters.AddWithValue("@Bankcode", ul.BankCode.Trim());
dbcommand.Parameters.AddWithValue("@AppId", Convert.ToInt64(ul.AppID.Trim()));
dbcommand.Parameters.AddWithValue("@ActivityId", ul.ActivityID.Trim());
dbcommand.Parameters.AddWithValue("@RequestType", Convert.ToInt64(ul.RequestType.Trim()));
dbcommand.Parameters.AddWithValue("@UMRNData", createsinglexml.Trim());
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
res.ResDescription = "Saved Successfully";
res.Status = "Success";
res.ActivityID = ds.Tables[1].Rows[0]["ActivityId"].ToString();
res.ResCode = "ykR30001";
res.FileNo = ds.Tables[1].Rows[0]["FileNo"].ToString();
res.BankCode = ds.Tables[1].Rows[0]["BankCode"].ToString();
res.CreatedDateTime = Convert.ToDateTime(ds.Tables[1].Rows[0]["CreatedDateTime"].ToString()).ToString("yyyy-MM-dd hh:mm");
res.LastEditDateTime = Convert.ToDateTime(ds.Tables[1].Rows[0]["LastEditDateTime"].ToString()).ToString("yyyy-MM-dd hh:mm");
res.TotalRecords = ds.Tables[0].Rows[0]["Recordcount"].ToString();
res.TotalAmt = ds.Tables[0].Rows[0]["TotalAmount"].ToString();
res.FileStatus = ds.Tables[1].Rows[0]["FileStatus"].ToString();
string GenerateXML = ""; string UMRN = ""; string AMOUNT = "";
string finalxml = "<UMDATA>";
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
UMRN = ds.Tables[2].Rows[i]["UMRN"].ToString();
AMOUNT = ds.Tables[2].Rows[i]["AMOUNT"].ToString();
GenerateXML = ValidatePresement.XMLCREATION(UMRN, AMOUNT, Convert.ToDateTime(ds.Tables[1].Rows[0]["LastEditDateTime"].ToString()).ToString("yyyy-MM-dd hh:mm"), ds.Tables[1].Rows[0]["FileStatus"].ToString());
finalxml += GenerateXML;
}
finalxml += "</UMDATA>";
res.UMRNData = finalxml;
return(res);
}
else
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
}
#endregion
}
else
{
res.ResDescription = "Invalid Data";
res.Status = "Failure";
res.ActivityID = ul.ActivityID;
res.ResCode = "ykR30012";
res.FileNo = "";
res.BankCode = ul.BankCode;
res.CreatedDateTime = "";
res.LastEditDateTime = "";
res.TotalRecords = "";
res.TotalAmt = "";
res.FileStatus = "";
res.UMRNData = ul.UMRNData;
return(res);
}
}
return(res);
}
public GetMandateResponseforQRcode ScanQRCode(ScanQRImage Data)
{
GetMandateResponseforQRcode response = new GetMandateResponseforQRcode();
try
{
if (Data.AppId == "")
{
response.message = "Incomplete data";
response.status = "Failure";
response.ResCode = "ERR000";
return(response);
}
else if (Data.AppId != "" && CheckMandateInfo.ValidateAppID(Data.AppId) != true)
{
response.message = "Invalid ApplicationId";
response.status = "Failure";
response.ResCode = "ykR20023";
return(response);
}
else if (ValidatePresement.CheckAccess(Data.AppId.Trim(), "A") != true)
{
response.message = "Unauthorized user";
response.status = "Failure";
response.ResCode = "ykR20038";
return(response);
}
else if (Data.EnitityMarchantKey == "")
{
response.message = "Incomplete data";
response.status = "Failure";
response.ResCode = "ERR000";
return(response);
}
else if (Data.EnitityMarchantKey != "" && CheckMandateInfo.ValidateEntityMerchantKey(Data.EnitityMarchantKey, Data.AppId) != true)
{
response.message = "Invalid EnitityMarchantKey";
response.status = "Failure";
response.ResCode = "ykR20021";
return(response);
}
else
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(Data.AppId)].ConnectionString);
bool Flag = false;
// string temp = ConfigurationManager.AppSettings["EnitityMarchantKey" + Data.AppId];
string UserId = "";
string query = "Sp_WebAPI";
//if (temp.Trim() == DBsecurity.Decrypt(Data.EnitityMarchantKey))
//{
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QueryType", "GetEntityUser");
cmd.Parameters.AddWithValue("@appId", Data.AppId);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
UserId = Convert.ToString(dt.Rows[0][0]);
Flag = true;
}
// }
if (Flag)
{
con.Open();
query = "Sp_WebAPI";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QueryType", "GetMandateStatus");
cmd.Parameters.AddWithValue("@MandateId", Data.MandateID);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt != null && dt.Rows.Count > 0)
{
response.message = "Successfully received";
response.ResCode = "KPY000";
response.status = "Success";
response.MandateId = Data.MandateID;
response.Mandatestatus = Convert.ToString(dt.Rows[0]["status"]);
}
}
}
if (Data.ScanImage == "")
{
response.message = "Incomplete data";
response.status = "Failure";
response.ResCode = "ERR000";
return(response);
}
if (Data.ScanImage == null)
{
response.message = "Incomplete data";
response.status = "Failure";
response.ResCode = "ERR000";
return(response);
}
if (Data.MandateID == "")
{
response.message = "Incomplete data";
response.status = "Failure";
response.ResCode = "ERR000";
return(response);
}
if (Data.MandateID == null)
{
response.message = "Incomplete data";
response.status = "Failure";
response.ResCode = "ERR000";
return(response);
}
else if (!CheckMandateInfo.CheckManadateID(Data.MandateID, Data.AppId))
{
response.message = "MandateId is not exist";
response.status = "Failure";
response.ResCode = "ERR0003";
return(response);
}
else
{
byte[] data = Convert.FromBase64String(Data.ScanImage);
var filename = Data.MandateID + ".jpg";
var path = "/QRCodeImage/";
bool exists = System.IO.Directory.Exists(HttpContext.Current.Server.MapPath(path));
if (!exists)
{
System.IO.Directory.CreateDirectory(HttpContext.Current.Server.MapPath(path));
}
var file = HttpContext.Current.Server.MapPath(path + filename);
System.IO.File.WriteAllBytes(file, data);
path = path + filename;
Bitmap bitmap1 = new Bitmap(file);
int x = 0, y = 0, width = 1531, height = 486;
Bitmap CroppedImage = bitmap1.Clone(new System.Drawing.Rectangle(x, y, width, height), bitmap1.PixelFormat);
LuminanceSource source;
source = new BitmapLuminanceSource(CroppedImage);
BinaryBitmap bitmap = new BinaryBitmap(new HybridBinarizer(source));
Result result = new MultiFormatReader().decode(bitmap);
string finalresult = result.ToString();
response.message = finalresult;
bitmap1.Dispose();
CroppedImage.Dispose();
System.GC.Collect();
System.GC.WaitForPendingFinalizers();
File.Delete(file);
return(response);
}
}
catch (Exception Ex)
{
response.message = "Incomplete data";
return(response);
}
}
