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()); }