public bool AddLowBalanceRecovery(int RecoveryId)
{
try
{
//using (var db = new SoneriCISEntities())
//{
// tbl_Recovery_Low_Balance row = new tbl_Recovery_Low_Balance();
// row.RecoveryID = RequsetId;
// row.RecoveryDate = DateTime.Now;
// db.tbl_Recovery_Low_Balance.Add(row);
// db.SaveChanges();
//}
//return true;
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@RecoveryId", RecoveryId));
var success = Convert.ToString(DatabaseGateway.GetScalarDataUsingStoredProcedure("sp_Add_Recovery_Low_Balance", param));
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool InsertNewRecovery(DateTime StartDate, DateTime EndDate)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@Date", StartDate));
param.Add(new SqlParameter("@ToDate", EndDate));
var success = Convert.ToString(DatabaseGateway.GetScalarDataUsingStoredProcedure("sp_Insert_New_Recovery_Records_Count", param));
return(true);
}
public static bool AddUserLog(int UserId, long?EntityId = null)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@EventName", "l"));
param.Add(new SqlParameter("@EntityName", "Login"));
param.Add(new SqlParameter("@EntityID", EntityId));
param.Add(new SqlParameter("@UserId", UserId));
var success = Convert.ToString(DatabaseGateway.GetScalarDataUsingStoredProcedure("sp_AddUserLog", param));
return(true);
}
public bool AddUserLog(string json, string entityName, string eventName, string entityId)
{
try
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@EventName", eventName));
param.Add(new SqlParameter("@EntityName", entityName));
param.Add(new SqlParameter("@EntityID", entityId));
param.Add(new SqlParameter("@UserId", int.Parse(Convert.ToString(HttpContext.Current.Session["UserId"]))));
param.Add(new SqlParameter("@Description", json));
var success = DatabaseGateway.GetScalarDataUsingStoredProcedure("sp_AddUserLog", param);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}