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