public ActionResult Delete(int JobCardQCId = 0)
{
try
{
if (JobCardQCId == 0)
{
return(RedirectToAction("Index", "Home"));
}
string ref_no = new JobCardQCRepository().DeleteJobCardQC(JobCardQCId);
TempData["Success"] = "Deleted Successfully! (" + ref_no + ")";
return(RedirectToAction("Index"));
}
catch (Exception)
{
TempData["error"] = "Some error occured while deleting. Please try again.";
return(RedirectToAction("Edit", new { id = JobCardQCId }));
}
}
public ActionResult Edit(int id = 0)
{
try
{
if (id != 0)
{
FillEmployee();
JobCardQC JobCardQC = new JobCardQC();
JobCardQC = new JobCardQCRepository().GetJobCardQC(id);
JobCardQC.JobCardQCParams = JobCardQCParamRepo.GetJobCardQCParamDt(id);
return(View(JobCardQC));
}
else
{
TempData["error"] = "That was an invalid/unknown request. Please try again.";
TempData["success"] = "";
}
}
catch (InvalidOperationException iox)
{
TempData["error"] = "Sorry, we could not find the requested item. Please try again.|" + iox.Message;
}
catch (SqlException sx)
{
TempData["error"] = "Some error occured while connecting to database. Please try again after sometime.|" + sx.Message;
}
catch (NullReferenceException nx)
{
TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message;
}
catch (Exception ex)
{
TempData["error"] = "Some error occured. Please try again.|" + ex.Message;
}
TempData["success"] = "";
return(RedirectToAction("Index"));
}
public ActionResult PendingJobCardQC()
{
try
{
JobCardQCRepository repo = new JobCardQCRepository();
var result = repo.GetPendingJobCardQC();
return(View("PendingJobCardQC", result));
}
catch (Exception ex)
{
string ErrorMessage = ex.Message.ToString();
if (ex.InnerException != null)
{
if (ex.InnerException.Message != null)
{
ErrorMessage = ErrorMessage + ex.InnerException.Message.ToString();
}
}
ViewData["Error"] = ErrorMessage;
return(View("ShowError"));
}
}
public ActionResult Print(int Id)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "JobCardQC.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
//-------HEAD
ds.Tables["Head"].Columns.Add("JobCardQCNoDate");
ds.Tables["Head"].Columns.Add("JobCardNoDate");
//ds.Tables["Head"].Columns.Add("JobCardQCRefNo");
//ds.Tables["Head"].Columns.Add("JobCardNo");
//ds.Tables["Head"].Columns.Add("JcDate");
//ds.Tables["Head"].Columns.Add("JobCardQCDate");
ds.Tables["Head"].Columns.Add("Customer");
ds.Tables["Head"].Columns.Add("VehicleModel");
ds.Tables["Head"].Columns.Add("EmployeeName");
ds.Tables["Head"].Columns.Add("Status");
ds.Tables["Head"].Columns.Add("DoorNo");
ds.Tables["Head"].Columns.Add("Street");
ds.Tables["Head"].Columns.Add("State");
ds.Tables["Head"].Columns.Add("Country");
ds.Tables["Head"].Columns.Add("Phone");
ds.Tables["Head"].Columns.Add("Fax");
ds.Tables["Head"].Columns.Add("Email");
ds.Tables["Head"].Columns.Add("ContactPerson");
ds.Tables["Head"].Columns.Add("Zip");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
//-------DT
ds.Tables["Items"].Columns.Add("ParaName");
ds.Tables["Items"].Columns.Add("QCParamName");
ds.Tables["Items"].Columns.Add("QCParamValue");
JobCardQCRepository repo = new JobCardQCRepository();
var Head = repo.GetJobCardQCHDPrint(Id, OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["JobCardQCNoDate"] = Head.JobCardQCNoDate;
dr["JobCardNoDate"] = Head.JobCardNoDate;
// dr["JcDate"] = Head.JcDate.ToString("dd-MMM-yyyy"); ;
// dr["JobCardQCDate"] = Head.JobCardQCDate.ToString("dd-MMM-yyyy"); ;
dr["Customer"] = Head.Customer;
dr["VehicleModel"] = Head.VehicleModel;
dr["EmployeeName"] = Head.EmployeeName;
dr["Status"] = Head.QCPassed;
dr["DoorNo"] = Head.DoorNo;
dr["Street"] = Head.Street;
dr["State"] = Head.State;
dr["Country"] = Head.CountryName;
dr["Phone"] = Head.Phone;
dr["Fax"] = Head.Fax;
dr["Email"] = Head.Email;
dr["ContactPerson"] = Head.ContactPerson;
dr["Zip"] = Head.Zip;
// dr["CurrencyName"] = Head.CurrencyName;
dr["OrganizationName"] = Head.OrganizationName;
dr["Image1"] = Head.Image1;
ds.Tables["Head"].Rows.Add(dr);
JobCardQCParamRepository repo1 = new JobCardQCParamRepository();
var Items = repo1.GetJobCardQCParamDtPrint(Id);
foreach (var item in Items)
{
var pritem = new JobCardQCParam
{
ParaName = item.ParaName,
QCParamName = item.QCParamName,
QCParamValue = item.QCParamValue,
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["ParaName"] = pritem.ParaName;
dri["QCParamName"] = pritem.QCParamName;
dri["QCParamValue"] = pritem.QCParamValue;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "JobCardQC.xml"), XmlWriteMode.WriteSchema);
rd.SetDataSource(ds);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", String.Format("JobCardQC{0}.pdf", Id.ToString())));
}
catch (Exception ex)
{
throw;
}
}
