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