private void Manage()
{
//Response.Write(ExpenseShareBAL.ManageExpenseShare(Request.QueryString).ToJSON());
try
{
string result = ExpenseShareBAL.ManageExpenseShare(Request.QueryString, Request.Form);
//var revolvingfund = new ExpenseShare
//{
// //ESID = Convert.ToInt32(result.Split(',')[0]),
// ESID = Convert.ToInt32(result[0]),
//};
var expenseshare = new ExpenseShare
{
ESID = Convert.ToInt32(result.Split(',')[0]),
ESDate = result.Split(',')[1],
Particulars = result.Split(',')[2],
AmtExpenseShare = Convert.ToDecimal(result.Split(',')[3])
};
Response.Write(expenseshare.ToJSON());
}
catch (Exception ex)
{
var appError = new ApplicationError
{
ErrorMessage = ex.Message,
ErrorCode = 999
};
Response.Write(appError.ToJSON());
}
}
public static List <ExpenseShare> GetExpenseShare(string criteria)
{
var dbUtil = new DatabaseManager();
var expenseshare = new List <ExpenseShare>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spAcctGetExpShareHeader";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@strCriteria", criteria);
//cmd.Parameters.AddWithValue("@intIDMasLocation", branchid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var revolvingFund = new ExpenseShare
{
ESID = ReferenceEquals(reader["ESID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ESID"]),
ESDate = ReferenceEquals(reader["ESDate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["ESDate"]),
AmtExpenseShare = ReferenceEquals(reader["AmtExpenseShare"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["AmtExpenseShare"]),
Particulars = ReferenceEquals(reader["Particulars"], DBNull.Value) ? String.Empty : Convert.ToString(reader["Particulars"]),
IsPosted = !ReferenceEquals(reader["Posted"], DBNull.Value) && Convert.ToBoolean(reader["Posted"]),
};
expenseshare.Add(revolvingFund);
}
return(expenseshare);
}
}
}
}
