public JsonResult CreateWOTypeA(int WOTypeId, string WOName, string CategoryCode, string code, string desc, bool status) { System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { Int32 returnValue = -2; int checkSession = UserLogin.AuthenticateRequest(); int createdBy = Convert.ToInt32(Session["UserID"]); if (checkSession == 0) { return Json(returnValue); } else { var data = new WOTypes { WOTypeId = WOTypeId, WOCategoryCode = CategoryCode, WOCode = HttpUtility.UrlDecode(code), WOName = HttpUtility.UrlDecode(WOName), WODescription = HttpUtility.UrlDecode(desc), Status = status, CreatedBy = createdBy }; int result = data.InsertOrUpdateWOType(); return Json(result); } } catch (Exception ex) { log.Error("Error: " + ex); return Json(""); } finally { log.Debug("End: " + methodBase.Name); } }
private WOTypes FetchService(WOTypes wotypes, SafeDataReader dr) { wotypes.WOTypeId = dr.GetInt32("ID"); wotypes.WOName = dr.GetString("Name"); wotypes.WOCategoryCode = dr.GetString("CategoryCode"); wotypes.WOCode = dr.GetString("Code"); wotypes.WODescription = dr.GetString("Description"); wotypes.Status = dr.GetBoolean("Status"); return wotypes; }
/// <summary> /// Created By : Sudheer /// Created Date : 15 Sep 2014 /// Modified By : /// Modified Date : /// Description : To Insert or Update the WOType A /// </summary> public static WOTypes GetWOTypeById(int? id) { var wotype = new WOTypes(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@id", id); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetWOTypeById]", sqlParams); while (reader.Read()) { wotype.FetchService(wotype, new SafeDataReader(reader)); } return wotype; } catch (Exception ex) { log.Error("Error: " + ex); return wotype; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Created By : Sudheer /// Created Date : 15 Sep 2014 /// Modified By : /// Modified Date : /// Description : To Insert or Update the WOType A /// </summary> public static WOTypeInfo GetAllWOTypes(int startPage, int resultPerPage, string Name, int status, string OrderBy) { var data = new WOTypeInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[5]; sqlParams[0] = new SqlParameter("@startPage", startPage); sqlParams[1] = new SqlParameter("@resultPerPage", resultPerPage); sqlParams[2] = new SqlParameter("@Name", Name); sqlParams[3] = new SqlParameter("@status", status); sqlParams[4] = new SqlParameter("@OrderBy", OrderBy); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetAllMWOType]", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var wotype = new WOTypes(); wotype.FetchService(wotype, safe); data.WOTypeList.Add(wotype); data.wotypeCount = Convert.ToInt32(reader["wotypecount"]); } return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }