/// <summary>
/// Description : To Get Service Which you want to Edit
/// Created By : Anji
/// Created Date : 03 May 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <param name="serviceId">pass the Service id which Service details you wont </param>
/// <returns>it will give service </returns>
public static Service GetServiceById(int? id)
{
var services = new Service();
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, "SpGetServiceById", sqlParams);
while (reader.Read())
{
services.FetchService(services, new SafeDataReader(reader));
}
return services;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return services;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
/// <summary>
/// Description : To Show all the Services in View
/// Created By : Anji
/// Created Date : 03 May 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns>it will give all the Service details available in database</returns>
public static ServiceInfo GetAllServices(int startPage, int resultPerPage, string code, int status, string OrderBy)
{
var data = new ServiceInfo();
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("@code", code);
sqlParams[3] = new SqlParameter("@status", status);
sqlParams[4] = new SqlParameter("@OrderBy", OrderBy);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetAllMServices]", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var service = new Service();
service.FetchService(service, safe);
data.ServiceList.Add(service);
data.ServiceCount = Convert.ToInt32(reader["serviceCount"]);
}
return data;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}