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