public JsonResult DeleteWorkOrderById(int ID, string StatusCode) { System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { int checkSession = UserLogin.AuthenticateRequest(); if (checkSession == 0) { return Json(checkSession); } else { WorkOrders objWO = new WorkOrders(); int result = objWO.DeleteWorkOrderById(ID, StatusCode); return Json(result); } } catch (Exception ex) { log.Error("Error: " + ex); return Json(""); } finally { log.Debug("End: " + methodBase.Name); } }
private WorkOrders FetchWorkOrderType(WorkOrders SerchWO, SafeDataReader dr) { SerchWO.Code = dr.GetString("Code"); SerchWO.Name = dr.GetString("Name"); return SerchWO; }
private WorkOrders FetchWOTypeOrCategory(WorkOrders WOTypeOrCategory, SafeDataReader dr) { WOTypeOrCategory.Name = dr.GetString("Name"); WOTypeOrCategory.Code = dr.GetString("Code"); return WOTypeOrCategory; }
private WorkOrders FetchingSerchWOData(WorkOrders SerchWO, SafeDataReader dr) { SerchWO.ID = dr.GetInt32("ID"); SerchWO.RefID = SerchWO.ID; SerchWO.WorkOrderType = dr.GetString("Type"); // SerchWO.Description = dr.GetString("Description"); SerchWO.Status = dr.GetBoolean("Status"); SerchWO.EditStatus = dr.GetBoolean("EditStatus"); SerchWO.WorkOrderTypeText = dr.GetString("wotypetext"); SerchWO.ClientId = dr.GetString("ClientName"); SerchWO.WorkOrderID = dr.GetString("WOCode"); SerchWO.NoteCount = dr.GetInt32("NoteCount"); SerchWO.NoteType = dr.GetString("NoteType"); SerchWO.StatusCode = dr.GetString("Name"); SerchWO.BillingPartyName = dr.GetString("BillingPartyName"); SerchWO.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt"); SerchWO.IsAdhoc = dr.GetBoolean("IsAdhoc"); SerchWO.IsPostedToCss1 = dr.GetBoolean("IsPostedToCss1"); return SerchWO; }
private WorkOrders FetchingSerchWODataByWO(WorkOrders SerchWO, SafeDataReader dr) { SerchWO.ID = dr.GetInt32("ID"); SerchWO.ClientId = dr.GetString("ClientCode"); SerchWO.WOCode = dr.GetString("WOCode"); SerchWO.GroupCode = dr.GetString("GroupCode"); SerchWO.IsBillable = dr.GetBoolean("IsBillable"); SerchWO.IsAdhoc = dr.GetBoolean("IsAdhoc"); SerchWO.IsPostedToCss1 = dr.GetBoolean("IsPostedToCss1"); SerchWO.CategoryCode = dr.GetString("CategoryCode"); SerchWO.SourceID = dr.GetString("SourceID"); SerchWO.WorkOrderType = dr.GetString("Type"); SerchWO.ClientName = dr.GetString("ClientName"); SerchWO.StatusCode = dr.GetString("StatusCode"); // SerchWO.Status = dr.GetBoolean("Status"); SerchWO.WorkOrderTypeText = dr.GetString("TypeName"); SerchWO.BillingPartyName = dr.GetString("BillingParty"); SerchWO.BillingPartyID = dr.GetInt32("BillingPartyID"); SerchWO.BillingPartySourceID = dr.GetString("BillingPartySourceID"); SerchWO.Description = dr.GetString("Description"); return SerchWO; }
/// <summary> /// Description : Get ID and Name from MWorkOrderType from database for Type dropdown in WorkOrder. /// Created By : Shiva /// Created Date : 20 May 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static WorkOrderInfo GetWorkOrderType() { var data = new WorkOrderInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { var lstWorkOrder = new List<WorkOrders>(); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetMWorkOrderType"); var safe = new SafeDataReader(reader); while (reader.Read()) { var getIDFromDIType = new WorkOrders(); getIDFromDIType.FetchWorkOrderType(getIDFromDIType, safe); lstWorkOrder.Add(getIDFromDIType); } data.WorkOrdersList = lstWorkOrder; return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Description : To Show all the Workorders SearchWO List /// Created By : hussain /// Created Date : 27 May 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns>it will give all the Workorders details available in database</returns> public static WorkOrderInfo GetWorkOrderDetailsById(int ID) { var data = new WorkOrderInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { var getWorkOrder = new List<WorkOrders>(); SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@ID", ID); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetWorkorderById", sqlParams); var WorkOrderList = new WorkOrders(); var safe = new SafeDataReader(reader); while (reader.Read()) { WorkOrderList.FetchingSerchWODataByWO(WorkOrderList, safe); getWorkOrder.Add(WorkOrderList); } data.WorkOrdersList = getWorkOrder; reader.NextResult(); while (reader.Read()) { var Assignment = new WOAssignment(); Assignment.FetchWOAssignmentDetails(Assignment, safe); data.WOAssignment.Add(Assignment); } return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Description : To Show all the Workorders SearchWO List /// Created By : hussain /// Created Date : 27 May 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns>it will give all the Workorders details available in database</returns> public static WorkOrderInfo GetSerchWOData(string ClientId, string SourceID, string WorkOrderID, string statusCode, int startpage, int rowsperpage, string Type, string OrderBy, string FromDate, string ToDate, int CreatedBy, string IsAdhoc, string AssignedTo) { var data = new WorkOrderInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { var getWorkOrder = new List<WorkOrders>(); SqlParameter[] sqlParams = new SqlParameter[13]; sqlParams[0] = new SqlParameter("@startPage", startpage); sqlParams[1] = new SqlParameter("@resultPerPage", rowsperpage); sqlParams[2] = new SqlParameter("@ClientId", ClientId); sqlParams[3] = new SqlParameter("@SourceID", SourceID); sqlParams[4] = new SqlParameter("@WorkOrderID", WorkOrderID); sqlParams[5] = new SqlParameter("@status", statusCode); sqlParams[6] = new SqlParameter("@Type", Type); sqlParams[7] = new SqlParameter("@OrderBy", OrderBy); sqlParams[8] = new SqlParameter("@FromDate", HelperClasses.ConvertDateFormat(FromDate)); sqlParams[9] = new SqlParameter("@ToDate", HelperClasses.ConvertDateFormat(ToDate)); sqlParams[10] = new SqlParameter("@CreatedBy", CreatedBy); sqlParams[11] = new SqlParameter("@IsAdhoc", IsAdhoc); sqlParams[12] = new SqlParameter("@AssignedTo", AssignedTo); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetAllWorkOrder]", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var WorkOrderList = new WorkOrders(); WorkOrderList.FetchingSerchWOData(WorkOrderList, safe); getWorkOrder.Add(WorkOrderList); data.workorderCount = Convert.ToInt32(reader["Workordercount"]); } data.WorkOrdersList = getWorkOrder; return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Description : To get MWOType by Category Code. /// Created By : Shiva /// Created Date : 15 July 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static WorkOrderInfo GetMWOTypeByCategoryCode(string CategoryCode) { var WOTypeByCategoryCodeData = new WorkOrderInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { var lstWOType = new List<WorkOrders>(); SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@CategoryCode", CategoryCode); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetMWOTypeByCategoryCode", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var GetMWOType = new WorkOrders(); GetMWOType.FetchWOTypeOrCategory(GetMWOType, safe); lstWOType.Add(GetMWOType); } WOTypeByCategoryCodeData.WorkOrdersList = lstWOType; return WOTypeByCategoryCodeData; } catch (Exception ex) { log.Error("Error: " + ex); return WOTypeByCategoryCodeData; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Description : To get DashBord Details. /// Created By : Sudheer /// Created Date : 7th Oct 2014 /// Modified By : /// Modified Date: /// </summary> /// <returns></returns> public static object GetDashbordDetails() { var data = new WorkOrderInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { var getWorkOrder = new List<WorkOrders>(); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetDashbordDetails"); var safe = new SafeDataReader(reader); while (reader.Read()) { var WorkOrderList = new WorkOrders(); WorkOrderList.FetchingSerchWOData(WorkOrderList, safe); getWorkOrder.Add(WorkOrderList); data.workorderCount = Convert.ToInt32(reader["Workordercount"]); } data.WorkOrdersList = getWorkOrder; return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }