public JsonResult GetWOCessionofficersPossionDetailsByCessId(int CessID)
{
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
var result = new CessionofficersInfo();
int checkSession = UserLogin.AuthenticateRequest();
if (checkSession == 0)
{
return Json(checkSession);
}
else
{
result = Cessionofficers.GetWOCessionofficersPossionDetails(CessID);
}
return Json(result.DirectorsList);
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return Json("");
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : Get Directors Details from database.
/// Created By : Sudheer
/// Created Date : 20 Nov 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns></returns>
public static CessionofficersInfo GetCessationDirectors(int WOID, int DirectorID, string DirectorSource, int NatureAppoint)
{
var data = new CessionofficersInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[4];
sqlParams[0] = new SqlParameter("@WOID", WOID);
sqlParams[1] = new SqlParameter("@DirctorID", DirectorID);
sqlParams[2] = new SqlParameter("@DirectorSource", DirectorSource);
sqlParams[3] = new SqlParameter("@NatureofOppintment", NatureAppoint);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetDirectorDetailsforCessationOfficer]", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var directors = new Cessionofficers();
directors.CessationDirectors(directors, safe);
data.DirectorsList.Add(directors);
}
return data;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
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 CessionofficersInfo GetWOCessionofficersPossionDetails(int CessId)
{
var GetWOCessionData = new CessionofficersInfo();
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("@CessId", CessId);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetCessionofficersPossionDetails", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var Details = new Cessionofficers();
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 DeleteCessationOfficerDetails(int ID)
{
int Rerurn = -1;
var GetWOCessionData = new CessionofficersInfo();
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, "[SPDeleteCessationOfficerDetailsByID]", sqlParams);
Rerurn = Convert.ToInt16(sqlParams[1].Value);
return Rerurn;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return Rerurn;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
