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