public int InsertJobCardQC(JobCardQC objJobCardQC)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction trn = connection.BeginTransaction();
try
{
int id = 0;
string internalId = DatabaseCommonRepository.GetNewDocNo(connection, objJobCardQC.OrganizationId, 17, true, trn);
objJobCardQC.JobCardQCRefNo = internalId;
string sql = @"INSERT INTO JobCardQC(JobCardId,JobCardQCRefNo,EmployeeId,JobCardQCDate,IsQCPassed,CreatedBy,CreatedDate,OrganizationId,Remarks, PunchingNo)
VALUES (@JobCardId,@JobCardQCRefNo,@EmployeeId,GETDATE(),@IsQCPassed,@CreatedBy,GETDATE(),@OrganizationId,@Remarks, @PunchingNo);
SELECT CAST(SCOPE_IDENTITY() as int)";
id = connection.Query <int>(sql, objJobCardQC, trn).Single();
var JobCardQCParamRepo = new JobCardQCParamRepository();
foreach (var item in objJobCardQC.JobCardQCParams)
{
item.JobCardQCId = id;
JobCardQCParamRepo.InsertSaleOrderItem(item, connection, trn);
}
InsertLoginHistory(dataConnection, objJobCardQC.CreatedBy, "Create", "Job Card QC", id.ToString(), "0");
trn.Commit();
return(id);
}
catch (Exception)
{
trn.Rollback();
return(0);
}
}
}
public ActionResult Save(JobCardQC model)
{
if (!ModelState.IsValid)
{
FillEmployee();
return(View("Create", model));
}
//try
//{
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
if (new JobCardQCRepository().InsertJobCardQC(model) > 0)
{
TempData["Success"] = "Saved Successfully! Reference No. is " + model.JobCardQCRefNo;
return(RedirectToAction("PendingJobCardQC"));
}
else
{
TempData["error"] = "Some error occurred while saving. Please try again.";
FillEmployee();
return(View("Create", model));
}
}
public ActionResult Create(int Id, string No, DateTime JcDate, string Customer, string VehicleModel)
{
try
{
FillEmployee();
JobCardQC objJCQC = new JobCardQC();
objJCQC = JobCardQCRepo.GetJobCardDetails(Id, OrganizationId);
objJCQC.JobCardQCRefNo = DatabaseCommonRepository.GetNextDocNo(17, OrganizationId);
objJCQC.CurrentDate = System.DateTime.Today;
objJCQC.JobCardQCParams = JobCardQCParamRepo.GetJobCardQCParamList();
return(View(objJCQC));
}
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 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 int UpdateJobCardQC(JobCardQC objJobCardQC)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction txn = connection.BeginTransaction();
string sql = @"UPDATE
JobCardQC SET JobCardQCRefNo=@JobCardQCRefNo,EmployeeId=@EmployeeId,
JobCardQCDate=@JobCardQCDate,IsQCPassed=@IsQCPassed,CreatedBy=@CreatedBy,
CreatedDate=@CreatedDate,OrganizationId=@OrganizationId,Remarks=@Remarks,
PunchingNo = @PunchingNo
WHERE JobCardId = @JobCardId;";
try
{
var id = connection.Execute(sql, objJobCardQC, txn);
int i = 0;
var JobCardQCParamRepo = new JobCardQCParamRepository();
foreach (var item in objJobCardQC.JobCardQCParams)
{
item.JobCardQCId = objJobCardQC.JobCardQCId;
JobCardQCParamRepo.InsertSaleOrderItem(item, connection, txn);
}
InsertLoginHistory(dataConnection, objJobCardQC.CreatedBy, "Update", "Project Completion", id.ToString(), objJobCardQC.OrganizationId.ToString());
txn.Commit();
return(id);
}
catch (Exception ex)
{
txn.Rollback();
throw ex;
}
}
}
public ActionResult Edit(JobCardQC model)
{
FillEmployee();
try
{
model.CreatedBy = UserID.ToString(); model.CreatedDate = DateTime.Today; model.OrganizationId = OrganizationId;
if (model.JobCardQCParams != null && model.JobCardQCParams.Count > 0)
{
new JobCardQCParamRepository().DeleteJobCardQCParam(model.JobCardQCId);
}
new JobCardQCRepository().UpdateJobCardQC(model);
TempData["success"] = "Updated Successfully (" + model.JobCardQCRefNo + ")";
return(RedirectToAction("Index"));
}
catch (Exception)
{
TempData["error"] = "Some error occurred. Please try again.";
}
return(View(model));
}
