public static IBPPayoutBranchEntries_ManageResultString SaveSelectedPayout(NameValueCollection querystring, NameValueCollection formdata) { UserProfile userProfile = WebCommon.GetUserProfile(); var cvList = new List <IBPPayoutBranchEntries_BranchSale>(); string strData1; int intParser; strData1 = formdata[0].ToString().Substring(formdata[0].ToString().IndexOf("],[") + 1, formdata[0].Length - formdata[0].ToString().IndexOf("],[") - 1); cvList = (List <IBPPayoutBranchEntries_BranchSale>)cvList.ToClass(strData1); var mst = new IBPPayoutBranchEntries_BranchEntry { intIDIBPPayoutBranch = int.TryParse(querystring.Get("intIDIBPPayoutBranch"), out intParser) ? intParser : 0, TransactionDate = querystring.Get("TransactionDate"), intIBPPayout = int.TryParse(querystring.Get("intIBPPayout"), out intParser) ? intParser : 0, TotalAmount = decimal.Parse(querystring.Get("TotalAmount")), strParticulars = querystring.Get("strParticulars"), intIDSecUser = int.Parse(userProfile.UserId.ToString()) }; string param = WebCommon.ToXML(cvList); return(IBPPayoutBranchEntriesDAL.SaveSelectedPayout(mst, param)); }
public static IBPPayoutBranchEntries_ManageResultString SaveSelectedPayout(IBPPayoutBranchEntries_BranchEntry brEntry, string xml) { var manageResult = new IBPPayoutBranchEntries_ManageResultString(); try { var dbUtil = new DatabaseManager(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { string result = string.Empty; conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisIBPPayoutBranchEntry_Manage"; cmd.CommandTimeout = 180; cmd.Parameters.AddWithValue("@intIDIBPPayoutBranch", brEntry.intIDIBPPayoutBranch); cmd.Parameters.AddWithValue("@TransactionDate", brEntry.TransactionDate); cmd.Parameters.AddWithValue("@intIBPPayout", brEntry.intIBPPayout); cmd.Parameters.AddWithValue("@TotalAmount", brEntry.TotalAmount); cmd.Parameters.AddWithValue("@strParticulars", brEntry.strParticulars); cmd.Parameters.AddWithValue("@intIDSecUser", brEntry.intIDSecUser); cmd.Parameters.AddWithValue("@xmlXML", xml); result = (string)cmd.ExecuteScalar(); } if (result.Contains("Success")) { string[] separators = { "," }; string[] words = result.Split(separators, StringSplitOptions.RemoveEmptyEntries); manageResult.Message = words[0].ToString(); manageResult.Code = words[1].ToString(); manageResult.ID = int.Parse(words[2].ToString()); } else { manageResult.Message = result; manageResult.Code = ""; manageResult.ID = 0; } } } catch (Exception ex) { manageResult.Message = "Error: " + ex.ToString(); manageResult.Code = ""; manageResult.ID = 0; } return(manageResult); }
public static List <IBPPayoutBranchEntries_BranchEntry> SearchTransaction(string strCriteria) { DatabaseManager dbUtil = new DatabaseManager(); var result = new List <IBPPayoutBranchEntries_BranchEntry>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisIBPPayoutBranchEntry_SearchTransaction"; cmd.Parameters.AddWithValue("@strCriteria", strCriteria); cmd.CommandTimeout = 180; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var item = new IBPPayoutBranchEntries_BranchEntry { intIDIBPPayoutBranch = int.Parse(reader["intIDIBPPayoutBranch"].ToString()), TransactionDate = reader["TransactionDate"].ToString(), intIBPPayout = int.Parse(reader["intIBPPayout"].ToString()), TotalAmount = decimal.Parse(reader["TotalAmount"].ToString()), strParticulars = reader["strParticulars"].ToString(), intIDSecUser = int.Parse(reader["intIDSecUser"].ToString()) }; result.Add(item); } return(result); } } } }