public AddEditMasters Add(SCRequest sData)
{
try
{
string stProc = AddSC;
var pList = new List <SqlParameter>
{
new SqlParameter("@CHCID", sData.chcId),
new SqlParameter("@PHCID", sData.phcId),
new SqlParameter("@HNIN_ID", sData.hninId ?? sData.hninId),
new SqlParameter("@SC_gov_code", sData.scGovCode),
new SqlParameter("@SCname", sData.scName ?? sData.scName),
new SqlParameter("@SCAddress", sData.scAddress.ToCharArray()),
new SqlParameter("@Pincode", sData.pincode ?? sData.pincode),
new SqlParameter("@Isactive", sData.isActive ?? sData.isActive),
new SqlParameter("@Latitude", sData.latitude ?? sData.latitude),
new SqlParameter("@Longitude", sData.longitude ?? sData.longitude),
new SqlParameter("@Comments", sData.comments ?? sData.comments),
new SqlParameter("@Createdby", sData.createdBy),
new SqlParameter("@Updatedby", sData.updatedBy),
};
var returnData = UtilityDL.FillEntity <AddEditMasters>(stProc, pList);
return(returnData);
}
catch (Exception e)
{
throw e;
}
}
public async Task <ActionResult> AddSC(SCRequest sData)
{
var addEditResponse = await _scService.Add(sData);
return(Ok(new AddEditResponse
{
Status = addEditResponse.Status,
Message = addEditResponse.Message,
}));
}
public async Task <AddEditResponse> Add(SCRequest sData)
{
var response = new AddEditResponse();
try
{
if (sData.isActive.ToLower() != "true")
{
sData.isActive = "false";
}
if (string.IsNullOrEmpty(sData.scGovCode))
{
response.Status = "false";
response.Message = "Please enter sc gov code";
}
else if (sData.chcId <= 0)
{
response.Status = "false";
response.Message = "Invalid CHC id";
}
else if (sData.phcId <= 0)
{
response.Status = "false";
response.Message = "Invalid PHC id";
}
else
{
var addEditResponse = _scData.Add(sData);
response.Status = "true";
response.Message = addEditResponse.message;
}
return(response);
}
catch (Exception e)
{
response.Status = "false";
response.Message = $"Unable to process - {e.Message}";
return(response);
}
}
public Collection <SCRequest> GetAllSCRequestData(SCRequest request)
{
request.SPCalled = "[DBO].[rpt_SCRequest_Lite]";
var dataCollection = new Collection <SCRequest>();
SqlDataReader reader = GetSPDetails(request);
while (reader.HasRows)
{
while (reader.Read())
{
SCRequest obj = new SCRequest();
obj.Number = reader["number"].ToString() == null ? "" : reader["number"].ToString();
obj.Resolved_Month = reader["Resolved_Month"].ToString() == null ? "" : reader["Resolved_Month"].ToString();
obj.Resolved_Month = reader["TTRwithExcludesInMinutes"].ToString() == null ? "" : reader["TTRwithExcludesInMinutes"].ToString();
obj.TTRwithExcludesInMinutes = Convert.ToInt32(reader["TTRwithExcludesInMinutes"]);
obj.RawTTRInMInutes = Convert.ToInt32(reader["RawTTRInMInutes"]);
obj.Open_Month = reader["Open_Month"].ToString() == null ? "" : reader["Open_Month"].ToString();
obj.Opened_By = reader["Opened_By"].ToString() == null ? "" : reader["Opened_By"].ToString();
obj.Impact = reader["Impact"].ToString() == null ? "" : reader["Impact"].ToString();
obj.Escalation = reader["Escalation"].ToString() == null ? "" : reader["Escalation"].ToString();
obj.Due_Date = DateTime.Now;
obj.Priority = reader["Priority"].ToString() == null ? "" : reader["Priority"].ToString();
obj.Request_State = reader["Request_State"].ToString() == null ? "" : reader["Request_State"].ToString();
obj.Requested_For = reader["Requested_For"].ToString() == null ? "" : reader["Requested_For"].ToString();
obj.Short_Description = reader["Short_Description"].ToString() == null ? "" : reader["Short_Description"].ToString();
obj.Stage = reader["Stage"].ToString() == null ? "" : reader["Stage"].ToString();
obj.State = reader["State"].ToString() == null ? "" : reader["State"].ToString();
obj.BPIT = reader["BPIT"].ToString() == null ? "" : reader["BPIT"].ToString();
obj.Assignment_Group = reader["Assignment_Group"].ToString() == null ? "" : reader["Assignment_Group"].ToString();
dataCollection.Add(obj);
}
reader.NextResult();
}
return(dataCollection);
}
public Collection <SCRequest> GetAllSCRequestData(SCRequest request)
{
return(_repository.GetAllSCRequestData(request));
}
// GET: SBOSvcCtr
public ActionResult Index()
{
IEnumerable <SCRequestModel> scRequestModelList = null;
var modelObj = new SCRequest();
var SCRequestData = new Collection <SCRequest>();
PivotService _pivotService = new PivotService();
try
{
SCRequestData = _pivotService.GetAllSCRequestData(modelObj);
scRequestModelList = (from item in SCRequestData
select new SCRequestModel
{
Number = item.Number,
Resolved_Month = item.Resolved_Month,
TTRwithExcludesInMinutes = item.TTRwithExcludesInMinutes,
RawTTRInMInutes = item.RawTTRInMInutes,
Open_Month = item.Open_Month,
Opened_By = item.Opened_By,
Impact = item.Impact,
Escalation = item.Escalation,
Due_Date = item.Due_Date,
Priority = item.Priority,
Request_State = item.Request_State,
Requested_For = item.Requested_For,
Short_Description = item.Short_Description,
Stage = item.Stage,
State = item.State,
BPIT = item.BPIT,
Assignment_Group = item.Assignment_Group
}).Take(500);
DataTable dt = new DataTable();
DataColumn col1 = new DataColumn();
col1.DataType = System.Type.GetType("System.String");
col1.ColumnName = "Number";
DataColumn col2 = new DataColumn();
col2.DataType = System.Type.GetType("System.String");
col2.ColumnName = "Resolved_Month";
DataColumn col3 = new DataColumn();
col3.DataType = System.Type.GetType("System.Int32");
col3.ColumnName = "TTRwithExcludesInMinutes";
DataColumn col4 = new DataColumn();
col4.DataType = System.Type.GetType("System.Int32");
col4.ColumnName = "RawTTRInMInutes";
DataColumn col5 = new DataColumn();
col5.DataType = System.Type.GetType("System.String");
col5.ColumnName = "Open_Month";
DataColumn col6 = new DataColumn();
col6.DataType = System.Type.GetType("System.String");
col6.ColumnName = "Opened_By";
DataColumn col7 = new DataColumn();
col7.DataType = System.Type.GetType("System.String");
col7.ColumnName = "Impact";
DataColumn col8 = new DataColumn();
col8.DataType = System.Type.GetType("System.String");
col8.ColumnName = "Escalation";
DataColumn col9 = new DataColumn();
col9.DataType = System.Type.GetType("System.DateTime");
col9.ColumnName = "Due_Date";
DataColumn col10 = new DataColumn();
col10.DataType = System.Type.GetType("System.String");
col10.ColumnName = "Priority";
DataColumn col11 = new DataColumn();
col11.DataType = System.Type.GetType("System.String");
col11.ColumnName = "Request_State";
DataColumn col12 = new DataColumn();
col12.DataType = System.Type.GetType("System.String");
col12.ColumnName = "Requested_For";
DataColumn col13 = new DataColumn();
col13.DataType = System.Type.GetType("System.String");
col13.ColumnName = "Short_Description";
DataColumn col14 = new DataColumn();
col14.DataType = System.Type.GetType("System.String");
col14.ColumnName = "Stage";
DataColumn col15 = new DataColumn();
col15.DataType = System.Type.GetType("System.String");
col15.ColumnName = "State";
DataColumn col16 = new DataColumn();
col16.DataType = System.Type.GetType("System.String");
col16.ColumnName = "BPIT";
DataColumn col17 = new DataColumn();
col17.DataType = System.Type.GetType("System.String");
col17.ColumnName = "Assignment_Group";
dt.Columns.Add(col1);
dt.Columns.Add(col2);
dt.Columns.Add(col3);
dt.Columns.Add(col4);
dt.Columns.Add(col5);
dt.Columns.Add(col6);
dt.Columns.Add(col7);
dt.Columns.Add(col8);
dt.Columns.Add(col9);
dt.Columns.Add(col10);
dt.Columns.Add(col11);
dt.Columns.Add(col12);
dt.Columns.Add(col13);
dt.Columns.Add(col14);
dt.Columns.Add(col15);
dt.Columns.Add(col16);
dt.Columns.Add(col17);
foreach (var item in scRequestModelList)
{
DataRow dr = dt.NewRow();
dr[0] = item.Number;
dr[1] = item.Resolved_Month;
dr[2] = item.TTRwithExcludesInMinutes;
dr[3] = item.RawTTRInMInutes;
dr[4] = item.Open_Month;
dr[5] = item.Opened_By;
dr[6] = item.Impact;
dr[7] = item.Escalation;
dr[8] = item.Due_Date;
dr[9] = item.Priority;
dr[10] = item.Request_State;
dr[11] = item.Requested_For;
dr[12] = item.Short_Description;
dr[13] = item.Stage;
dr[14] = item.State;
dr[15] = item.BPIT;
dr[16] = item.Assignment_Group;
dt.Rows.Add(dr);
}
var result = new StringBuilder();
for (int i = 0; i < dt.Columns.Count; i++)
{
result.Append(dt.Columns[i].ColumnName);
result.Append(i == dt.Columns.Count - 1 ? "\n" : ",");
}
foreach (DataRow row in dt.Rows)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
result.Append(row[i].ToString());
result.Append(i == dt.Columns.Count - 1 ? "\n" : ",");
}
}
Session["firstTimeSC"] = result;
string newFileName = AppDomain.CurrentDomain.BaseDirectory + "SBOSvcCtr_Jennifer.csv";
}
catch (Exception ex)
{
return(View("Error"));
}
return(View());
}
