public string SaveNewComplaint(ComplaintNew obj) { try { int usersno = (((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"]))).UserSNo; DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@Text_AWBNo", obj.Text_AWBNo), new SqlParameter("@AWBNo", obj.AWBNo), new SqlParameter("@MovementTypeSNo", obj.Type), new SqlParameter("@RaisedDate", obj.RaisedDate), new SqlParameter("@AccountSNo", obj.AccountSNo), new SqlParameter("@AccountNo", obj.AccountNo), new SqlParameter("@Name", obj.Name), new SqlParameter("@Address", obj.Address), new SqlParameter("@CitySNo", obj.CitySNo), new SqlParameter("@ContactNo", obj.ContactNo), new SqlParameter("@EmailId", obj.EmailId), new SqlParameter("@PreClaim", obj.PreliminaryClaim), new SqlParameter("@ComplaintSourceSNo", obj.ComplaintSourceSNo), new SqlParameter("@Text_ComplaintSourceSNo", obj.Text_ComplaintSourceSNo), new SqlParameter("@Description", obj.Description), new SqlParameter("@Expectation", obj.Expectation), new SqlParameter("@ComplaintStatusSNo", obj.ComplaintStatusSNo), new SqlParameter("@Text_ComplaintStatusSNo", obj.Text_ComplaintStatusSNo), new SqlParameter("@UserSno", usersno), new SqlParameter("@LoginCitySno", obj.LoginCitySno), new SqlParameter("@ComplaintImportancy", obj.ComplaintImportancy), new SqlParameter("@Text_ComplaintImportancy", obj.Text_ComplaintImportancy) }; ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "SaveNewComplaint", Parameters); return(CargoFlash.Cargo.Business.Common.CompleteDStoJSON(ds)); } catch (Exception ex)//(Exception ex) { throw ex; } }
private ComplaintNew GetRecordComplaint(string complaintSNo) { try { int usersno = (((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"]))).UserSNo; DataSet ds = new DataSet(); SqlParameter[] Parameters = { new SqlParameter("@ComplaintSNo", complaintSNo) }; //try //{ ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetComplaintRecord", Parameters); //return CargoFlash.Cargo.Business.Common.CompleteDStoJSON(ds); DataTable dt = new DataTable(); dt = ds.Tables[0]; ComplaintNew comp = new ComplaintNew(); foreach (DataRow dr in dt.Rows) { comp.ComplaintSourceSNo = Convert.ToInt32(dr["ComplaintSourceSNo"]); comp.Text_ComplaintSourceSNo = dr["Text_ComplaintSourceSNo"].ToString(); comp.Name = dr["Name"].ToString(); comp.EmailId = dr["EmailId"].ToString(); comp.ContactNo = dr["ContactNo"].ToString(); comp.Address = dr["Address"].ToString(); comp.Expectation = dr["Expectation"].ToString(); comp.Description = dr["Description"].ToString(); comp.PreliminaryClaim = Convert.ToBoolean(dr["PreClaim"]); comp.AccountNo = dr["AccountNo"].ToString(); comp.RaisedDate = Convert.ToDateTime(dr["RaisedDate"]).ToString(); comp.AWBNo = Convert.ToInt32(dr["AWBSNo"]); comp.Text_AWBNo = dr["AWBNo"].ToString(); comp.Text_CitySNo = dr["CityName"].ToString(); comp.CitySNo = Convert.ToInt32(dr["CitySNo"]); comp.ComplaintSNo = Convert.ToInt32(dr["SNo"]); comp.ComplaintStatusSNo = Convert.ToInt32(dr["ComplaintStatusSNo"]); comp.Text_ComplaintStatusSNo = dr["Text_ComplaintStatusSNo"].ToString(); comp.ComplaintNo = dr["ComplaintNo"].ToString(); comp.ComplaintImportancy = dr["ComplaintImportancy"].ToString(); comp.Text_ComplaintImportancy = dr["Text_ComplaintImportancy"].ToString(); comp.Type = (dr["MovementTypeSNo"].ToString()); if (!string.IsNullOrEmpty((dr["ClosedDate"]).ToString())) { comp.ClosedDate = Convert.ToDateTime(dr["ClosedDate"]).ToString(); } else { comp.ClosedDate = (dr["ClosedDate"]).ToString(); } } return(comp); //} //catch(Exception ex)//(Exception ex) (Exception ex) //{ // return null; //} } catch (Exception ex)//(Exception ex) { throw ex; } }