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