public JsonResult InsertApptOfcrDetails(Appoinmentofficers ApptOfcrdetails) { 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 { int createdBy = Convert.ToInt32(Session["UserID"]); int result = Appoinmentofficers.InsertAppoinmentDirectors(ApptOfcrdetails, createdBy); return Json(result); } } catch (Exception ex) { log.Error("Error: " + ex); return Json(""); } finally { log.Debug("End: " + methodBase.Name); } }
private Appoinmentofficers FetchPositionDetails(Appoinmentofficers Directors, SafeDataReader dr) { Directors.Name = dr.GetString("Director Name"); Directors.Position = dr.GetString("Position"); Directors.Email = dr.GetString("Email"); Directors.ContactNo = dr.GetString("Phone"); Directors.Fax = dr.GetString("Fax"); return Directors; }
private Appoinmentofficers FetchCessationOfficers(Appoinmentofficers Directors, SafeDataReader dr) { Directors.ID = dr.GetInt32("ApptID"); Directors.Name = dr.GetString("Appoinment Officer"); Directors.Position = dr.GetString("Position"); Directors.NatureAppoint = dr.GetInt32("NatureAppoint"); Directors.Email = dr.GetString("Email"); Directors.ContactNo = dr.GetString("Phone"); Directors.Fax = dr.GetString("Fax"); return Directors; }
/// <summary> /// Description : insert Directors Details To database. /// Created By : Sudheer /// Created Date : 20 Nov 2014 /// Modified By : /// Modified Date: /// </summary> public static int InsertAppoinmentDirectors(Appoinmentofficers Apptofdetails, int CreatedBy) { int Rerurn = -1; System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[12]; sqlParams[0] = new SqlParameter("@ClientID", Apptofdetails.ClientID); sqlParams[1] = new SqlParameter("@ClientSourceID", Apptofdetails.ClientSourceID); sqlParams[2] = new SqlParameter("@NatureAppoint", Apptofdetails.NatureAppoint); sqlParams[3] = new SqlParameter("@WOID", Apptofdetails.WOID); sqlParams[4] = new SqlParameter("@DependingDirectorID", Apptofdetails.DependingDirectorID); sqlParams[5] = new SqlParameter("@DependingDirectorSource", Apptofdetails.DependingDirectorSource); sqlParams[6] = new SqlParameter("@Email", Apptofdetails.Email); sqlParams[7] = new SqlParameter("@ContactNo", Apptofdetails.ContactNo); sqlParams[8] = new SqlParameter("@Fax", Apptofdetails.Fax); sqlParams[9] = new SqlParameter("@CreatedBy", CreatedBy); sqlParams[10] = new SqlParameter("@Output", 0); sqlParams[10].Direction = ParameterDirection.Output; SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpInsertAppointmentOfficer]", sqlParams); Rerurn = Convert.ToInt16(sqlParams[10].Value); return Rerurn; } catch (Exception ex) { log.Error("Error: " + ex); return Rerurn; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Created By : Sudheer /// Created Date : 21 Nov 2014 /// Modified By : /// Modified Date: /// Description : Get Cessionofficers Details by WOID /// </summary> /// <returns></returns> public static AppoinmentofficersInfo GetWOApptOfficersPossionDetails(int ApptId) { var GetWOCessionData = new AppoinmentofficersInfo(); 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("@ApptId", ApptId); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetAppointmentOfficerPossionDetails", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var Details = new Appoinmentofficers(); Details.FetchPositionDetails(Details, safe); GetWOCessionData.DirectorsList.Add(Details); } return GetWOCessionData; } catch (Exception ex) { log.Error("Error: " + ex); return GetWOCessionData; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Created By : Sudheer /// Created Date : 21 Nov 2014 /// Modified By : /// Modified Date: /// Description : Get Cessionofficers Details by WOID /// </summary> /// <returns></returns> public static int DeleteAppointmentOfficerDetails(int ID) { int Rerurn = -1; var GetWOCessionData = new Appoinmentofficers(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[2]; sqlParams[0] = new SqlParameter("@ID", ID); sqlParams[1] = new SqlParameter("@Output", 0); sqlParams[1].Direction = ParameterDirection.Output; SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SPDeleteAppointmentOfficerDetailsByID]", sqlParams); Rerurn = Convert.ToInt16(sqlParams[1].Value); return Rerurn; } catch (Exception ex) { log.Error("Error: " + ex); return Rerurn; } finally { log.Debug("End: " + methodBase.Name); } }