public void ErrorTracking(ErrorLog ex, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ErrorLog error = new ErrorLog();
error.Data = ex.Data.ToString();
error.GetType = ex.GetType.ToString();
error.InnerException = ex.InnerException.ToString();
error.Message = ex.Message.ToString();
error.Source = ex.Source.ToString();
error.DateTime = DateTime.Now;
error.UserID = ex.UserID;
//ce.AddToErrorLogs(error);
//ce.SaveChanges();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Sp_EnterErrorTracking";
cmd.Connection = svr.GetSqlConn(conn);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Data", error.Data);
cmd.Parameters.AddWithValue("GetType", error.GetType);
cmd.Parameters.AddWithValue("InnerException", error.InnerException);
cmd.Parameters.AddWithValue("Message", error.Message);
cmd.Parameters.AddWithValue("Source", error.Source);
cmd.Parameters.AddWithValue("DateTime", error.DateTime);
cmd.Parameters.AddWithValue("UserID", error.UserID);
cmd.ExecuteNonQuery();
}
protected DataSet fillds(String strquery, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
DataSet ds = new DataSet();
System.Data.SqlClient.SqlConnection sqlConn = new System.Data.SqlClient.SqlConnection("Data Source=" + conn[0] + ";Initial Catalog=" + conn[1] + "; User ID=" + conn[3] + "; Password="******";");
SqlDataAdapter da = new SqlDataAdapter(strquery, sqlConn);
ds.Reset();
da.Fill(ds);
return(ds);
}
public List <SP_GetInboxData_Result> GetInboxDetailByUserID(long UserID, string isAll, string WhereValue, string[] condetails)
{
BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(server.GetEntityConnection(condetails));
List <SP_GetInboxData_Result> lst = new List <SP_GetInboxData_Result>();
//lst = (from inbox in db.SP_GetInboxData(UserID, isAll)
// select inbox).ToList();
//return lst;
switch (WhereValue.ToLower())
{
case "today":
lst = (from inbox in db.SP_GetInboxData(UserID, "false")
where inbox.ECD == DateTime.Now
select inbox).ToList();
break;
case "tomorrow":
lst = (from inbox in db.SP_GetInboxData(UserID, "false")
where inbox.ECD == DateTime.Today.AddDays(1)
select inbox).ToList();
break;
case "overdue":
lst = (from inbox in db.SP_GetInboxData(UserID, "false")
where inbox.ECD < DateTime.Now.Date && inbox.TaskStatus == "New Task"
select inbox).ToList();
break;
case "today+overdue":
lst = (from inbox in db.SP_GetInboxData(UserID, "false")
where inbox.ECD <= DateTime.Now.Date && inbox.TaskStatus == "New Task"
select inbox).ToList();
break;
case "7days+overdue":
lst = (from inbox in db.SP_GetInboxData(UserID, "false")
where inbox.ECD <DateTime.Now.AddDays(7) && inbox.ECD> DateTime.Now && inbox.TaskStatus == "New Task"
select inbox).ToList();
break;
case "alltoday":
lst = (from inbox in db.SP_GetInboxData(UserID, "true")
where inbox.ECD == DateTime.Now.Date
select inbox).ToList();
break;
case "alltomorrow":
lst = (from inbox in db.SP_GetInboxData(UserID, "true")
where inbox.ECD == DateTime.Today.AddDays(1)
select inbox).ToList();
break;
case "alloverdue":
lst = (from inbox in db.SP_GetInboxData(UserID, "true")
where inbox.ECD < DateTime.Now.Date && inbox.TaskStatus == "New Task"
select inbox).ToList();
break;
case "alltoday+overdue":
lst = (from inbox in db.SP_GetInboxData(UserID, "true")
where inbox.ECD <= DateTime.Now.Date && inbox.TaskStatus == "New Task"
select inbox).ToList();
break;
case "all7days+overdue":
lst = (from inbox in db.SP_GetInboxData(UserID, "true")
where inbox.ECD <DateTime.Now.AddDays(7) && inbox.ECD> DateTime.Now && inbox.TaskStatus == "New Task"
select inbox).ToList();
break;
default:
lst = (from inbox in db.SP_GetInboxData(UserID, isAll)
orderby inbox.ECD ascending
select inbox).ToList();
break;
}
return(lst);
}
//<summary>
//insert record of Invetory into tDocument
//</summary>
//<returns></returns>
public int InsertInvetory(tInventoryHead Inv, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.tInventoryHeads.AddObject(Inv);
ce.SaveChanges();
return(Convert.ToInt32(Inv.ID));
}
