public static List <LtoIncentive_tblLtoIncentive> getIncentive(string strCriteria)
{
var dbUtil = new DatabaseManager();
var ltoList = new List <LtoIncentive_tblLtoIncentive>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spLtoIncentive_getIncentive";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", strCriteria);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var item = new LtoIncentive_tblLtoIncentive
{
intIDLtoIncentive = int.Parse(reader["intIDLtoIncentive"].ToString()),
datTransaction = reader["datTransaction"].ToString(),
intIDLtoRFBankAccounts = int.Parse(reader["intIDLtoRFBankAccounts"].ToString()),
intIDMasEmployeeLiaison = int.Parse(reader["intIDMasEmployeeLiaison"].ToString()),
liaisonName = reader["liaisonName"].ToString(),
intIDMasLocationHomebase = int.Parse(reader["intIDMasLocationHomebase"].ToString()),
Homebase = reader["Homebase"].ToString(),
intIDMasEmployeeLtoStaff = int.Parse(reader["intIDMasEmployeeLtoStaff"].ToString()),
LtoStaffName = reader["LtoStaffName"].ToString(),
intIDMasEmployeeSS = int.Parse(reader["intIDMasEmployeeSS"].ToString()),
SSName = reader["SSName"].ToString(),
intIDMasEmployeeCA = int.Parse(reader["intIDMasEmployeeCA"].ToString()),
CAName = reader["CAName"].ToString(),
intIDMasEmployeeAC = int.Parse(reader["intIDMasEmployeeAC"].ToString()),
ACName = reader["ACName"].ToString(),
intIDMasEmployeeAC2 = int.Parse(reader["intIDMasEmployeeAC2"].ToString()),
AC2Name = reader["AC2Name"].ToString(),
intIDMasEmployeeAC3 = int.Parse(reader["intIDMasEmployeeAC3"].ToString()),
AC3Name = reader["AC3Name"].ToString(),
Remarks = reader["Remarks"].ToString(),
LiaisonAmount = decimal.Parse(reader["LiaisonAmount"].ToString()),
SSAmount = decimal.Parse(reader["SSAmount"].ToString()),
CashierAmount = decimal.Parse(reader["CashierAmount"].ToString()),
WithholdingTax = decimal.Parse(reader["WithholdingTax"].ToString()),
DateApproved = reader["DateApproved"].ToString(),
datIncentive = reader["datIncentive"].ToString()
};
ltoList.Add(item);
}
return(ltoList);
}
}
}
}
public static ManageResult manage(NameValueCollection querystring, NameValueCollection formdata)
{
UserProfile userProfile = WebCommon.GetUserProfile();
var cvList = new List <LtoIncentive_SearchCVForProcessing>();
string strData1;
int intParser;
strData1 = formdata[0].ToString().Substring(formdata[0].ToString().IndexOf("],[") + 1, formdata[0].Length - formdata[0].ToString().IndexOf("],[") - 1);
cvList = (List <LtoIncentive_SearchCVForProcessing>)cvList.ToClass(strData1);
var mst = new LtoIncentive_tblLtoIncentive
{
intIDLtoIncentive = int.TryParse(querystring.Get("intIDLtoIncentive"), out intParser) ? intParser : 0,
datTransaction = querystring.Get("TransactionDate"),
intIDMasEmployeeLiaison = int.TryParse(querystring.Get("intIDMasEmployee"), out intParser) ? intParser : 0,
Homebase = querystring.Get("Homebase"),
intIDMasEmployeeLtoStaff = int.TryParse(querystring.Get("intIDMasEmployeeLtoStaff"), out intParser) ? intParser : 0,
intIDMasEmployeeSS = int.TryParse(querystring.Get("intIDMasEmployeeSS"), out intParser) ? intParser : 0,
intIDMasEmployeeCA = int.TryParse(querystring.Get("intIDMasEmployeeCA"), out intParser) ? intParser : 0,
intIDMasEmployeeAC = int.TryParse(querystring.Get("intIDMasEmployeeAC"), out intParser) ? intParser : 0,
intIDMasEmployeeAC2 = int.TryParse(querystring.Get("intIDMasEmployeeAC2"), out intParser) ? intParser : 0,
intIDMasEmployeeAC3 = int.TryParse(querystring.Get("intIDMasEmployeeAC3"), out intParser) ? intParser : 0,
Remarks = querystring.Get("Remarks"),
intIDSecUser = int.Parse(userProfile.UserId.ToString()),
LiaisonAmount = decimal.Parse(querystring.Get("LiaisonAmount")),
LtoStaffAmount = decimal.Parse(querystring.Get("LtoStaffAmount")),
SSAmount = decimal.Parse(querystring.Get("SSAmount")),
CashierAmount = decimal.Parse(querystring.Get("CashierAmount")),
WithholdingTax = decimal.Parse(querystring.Get("WithholdingTax")),
datIncentive = querystring.Get("IncentiveDate")
};
string isInsert = querystring.Get("TransType");
string param = WebCommon.ToXML(cvList);
return(LtoIncentiveDal.manage(param, mst));
}
public static ManageResult manage(string xml, LtoIncentive_tblLtoIncentive mst)
{
var manageResult = new ManageResult();
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 = "spLtoIncentive_manageLtoIncentive";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDLtoIncentive", mst.intIDLtoIncentive);
cmd.Parameters.AddWithValue("@datTransaction", mst.datTransaction);
cmd.Parameters.AddWithValue("@intIDLtoRFBankAccounts", mst.intIDMasEmployeeLiaison);
cmd.Parameters.AddWithValue("@intIDMasEmployeeLtoStaff", mst.intIDMasEmployeeLtoStaff);
cmd.Parameters.AddWithValue("@intIDMasEmployeeSS", mst.intIDMasEmployeeSS);
cmd.Parameters.AddWithValue("@intIDMasEmployeeCA", mst.intIDMasEmployeeCA);
cmd.Parameters.AddWithValue("@intIDMasEmployeeAC", mst.intIDMasEmployeeAC);
cmd.Parameters.AddWithValue("@intIDMasEmployeeAC2", mst.intIDMasEmployeeAC2);
cmd.Parameters.AddWithValue("@intIDMasEmployeeAC3", mst.intIDMasEmployeeAC3);
cmd.Parameters.AddWithValue("@Remarks", mst.Remarks);
cmd.Parameters.AddWithValue("@intIDSecUser", mst.intIDSecUser);
cmd.Parameters.AddWithValue("@LiaisonAmount", mst.LiaisonAmount);
cmd.Parameters.AddWithValue("@LtoStaffAmount", mst.LtoStaffAmount);
cmd.Parameters.AddWithValue("@SSAmount", mst.SSAmount);
cmd.Parameters.AddWithValue("@CashierAmount", mst.CashierAmount);
cmd.Parameters.AddWithValue("@WithholdingTax", mst.WithholdingTax);
cmd.Parameters.AddWithValue("@datIncentive", mst.datIncentive);
cmd.Parameters.AddWithValue("@xmlXML", xml);
result = (string)cmd.ExecuteScalar();
}
if (result.Contains("Success121"))
{
string[] separators = { "," };
string[] words = result.Split(separators, StringSplitOptions.RemoveEmptyEntries);
manageResult.Message = "Success";
manageResult.ID = int.Parse(words[1].ToString());
}
else
{
manageResult.Message = result;
manageResult.ID = 0;
}
}
}
catch (Exception ex)
{
manageResult.Message = "Error: " + ex.ToString();
manageResult.ID = 0;
}
return(manageResult);
}
