public static void AddSubcontractor(this tbl_subcontractor subcontractor, SubContractorViewModel subcontractorVm) { subcontractor.tenant_id = subcontractorVm.tenant_id; subcontractor.company_name = subcontractorVm.company_name; subcontractor.project_id = subcontractorVm.project_id; subcontractor.reg_No = subcontractorVm.reg_No; subcontractor.subcontractor_name = subcontractorVm.subcontractor_name; subcontractor.current_street = subcontractorVm.current_street; subcontractor.current_country = subcontractorVm.current_country; subcontractor.current_state = subcontractorVm.current_state; subcontractor.current_city = subcontractorVm.current_city; subcontractor.current_zip = subcontractorVm.current_zip; subcontractor.current_contact_number = subcontractorVm.current_contact_number; subcontractor.alternative_contactNumber = subcontractorVm.alternative_contactNumber; subcontractor.contractor_photo_file_name = subcontractorVm.contractor_photo_file_name; subcontractor.service_tax_no = subcontractorVm.service_tax_no; subcontractor.pan = subcontractorVm.pan; subcontractor.bank_account_no = subcontractorVm.bank_account_no; subcontractor.bank_name = subcontractorVm.bank_name; subcontractor.bank_branch = subcontractorVm.bank_branch; subcontractor.ifsc = subcontractorVm.ifsc; subcontractor.contractor_photo = subcontractorVm.contractor_photo; subcontractor.contractor_photo_file_type = subcontractorVm.contractor_photo_file_type; subcontractor.agreement = subcontractorVm.agreement; subcontractor.agreement_file_type = subcontractorVm.agreement_file_type; subcontractor.contractor_agreement_file_name = subcontractorVm.contractor_agreement_file_name; subcontractor.created_date = DateTime.Now; subcontractor.created_by = subcontractorVm.created_by; subcontractor.modified_date = DateTime.Now; subcontractor.modified_by = subcontractorVm.modified_by; }
public HttpResponseMessage SaveSubContractor(HttpRequestMessage request, SubContractorViewModel subcontractor) { return(CreateHttpResponse(request, () => { HttpResponseMessage response = null; if (!ModelState.IsValid) { response = request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } else { var newSubContractor = new tbl_subcontractor() { tenant_id = subcontractor.tenant_id, project_id = subcontractor.project_id, company_name = subcontractor.company_name, reg_No = subcontractor.reg_No, subcontractor_name = subcontractor.subcontractor_name, current_street = subcontractor.current_street, current_country = subcontractor.current_country, current_state = subcontractor.current_state, current_city = subcontractor.current_city, current_zip = subcontractor.current_zip, current_contact_number = subcontractor.current_contact_number, alternative_contactNumber = subcontractor.alternative_contactNumber, contractor_photo_file_name = subcontractor.contractor_photo_file_name, service_tax_no = subcontractor.service_tax_no, pan = subcontractor.pan, bank_account_no = subcontractor.bank_account_no, bank_name = subcontractor.bank_name, bank_branch = subcontractor.bank_branch, ifsc = subcontractor.ifsc, contractor_photo = subcontractor.contractor_photo, contractor_photo_file_type = subcontractor.contractor_photo_file_type, agreement = subcontractor.agreement, agreement_file_type = subcontractor.agreement_file_type, contractor_agreement_file_name = subcontractor.contractor_agreement_file_name, created_date = DateTime.Now, created_by = subcontractor.created_by, modified_date = DateTime.Now, modified_by = subcontractor.modified_by, email_id = subcontractor.email_id }; for (int i = 0; i < subcontractor.scomponentslist.Count; i++) { var newscComponents = new tbl_subcontractor_components(); newscComponents.tenant_id = subcontractor.tenant_id; newscComponents.project_id = subcontractor.project_id; newscComponents.subcontractor_id = newSubContractor.id; newscComponents.subcontractor_name = subcontractor.subcontractor_name; newscComponents.component_id = subcontractor.scomponentslist[i].component_id; newscComponents.component_name = subcontractor.scomponentslist[i].component_name; _subcontractorRepository.Add(newSubContractor); _scComponentsRepository.Add(newscComponents); } _unitOfWork.Commit(); response = request.CreateResponse <SubContractorViewModel>(HttpStatusCode.Created, subcontractor); } return response; })); }
public HttpResponseMessage UpdateSubContractor(HttpRequestMessage request, SubContractorViewModel subcontractorviewmodel) { return(CreateHttpResponse(request, () => { HttpResponseMessage response = null; if (!ModelState.IsValid) { response = request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } else { var existingUser = _subcontractorRepository.GetSingle(subcontractorviewmodel.id); existingUser.company_name = subcontractorviewmodel.company_name; existingUser.project_id = subcontractorviewmodel.project_id; existingUser.reg_No = subcontractorviewmodel.reg_No; existingUser.subcontractor_name = subcontractorviewmodel.subcontractor_name; existingUser.current_street = subcontractorviewmodel.current_street; existingUser.current_country = subcontractorviewmodel.current_country; existingUser.current_state = subcontractorviewmodel.current_state; existingUser.current_city = subcontractorviewmodel.current_city; existingUser.current_zip = subcontractorviewmodel.current_zip; existingUser.current_contact_number = subcontractorviewmodel.current_contact_number; existingUser.alternative_contactNumber = subcontractorviewmodel.alternative_contactNumber; existingUser.service_tax_no = subcontractorviewmodel.service_tax_no; existingUser.pan = subcontractorviewmodel.pan; existingUser.bank_account_no = subcontractorviewmodel.bank_account_no; existingUser.bank_name = subcontractorviewmodel.bank_name; existingUser.bank_branch = subcontractorviewmodel.bank_branch; existingUser.ifsc = subcontractorviewmodel.ifsc; existingUser.contractor_photo = subcontractorviewmodel.contractor_photo; existingUser.contractor_photo_file_type = subcontractorviewmodel.contractor_photo_file_type; existingUser.contractor_photo_file_name = subcontractorviewmodel.contractor_photo_file_name; existingUser.contractor_agreement_file_name = subcontractorviewmodel.contractor_agreement_file_name; existingUser.agreement = subcontractorviewmodel.agreement; existingUser.agreement_file_type = subcontractorviewmodel.agreement_file_type; existingUser.modified_date = DateTime.Now; existingUser.modified_by = subcontractorviewmodel.modified_by; existingUser.email_id = subcontractorviewmodel.email_id; _subcontractorRepository.Edit(existingUser); //deleting existing comps.. var existingSc_id_sc_comps = _scComponentsRepository.GetAll().Where(s => s.subcontractor_id == subcontractorviewmodel.id); foreach (var sc_comp in existingSc_id_sc_comps) { _scComponentsRepository.Delete(sc_comp); } //adding new comps.. for (int i = 0; i < subcontractorviewmodel.scomponentslist.Count; i++) { var newscComponents = new tbl_subcontractor_components(); newscComponents.tenant_id = subcontractorviewmodel.tenant_id; newscComponents.project_id = subcontractorviewmodel.project_id; newscComponents.subcontractor_id = subcontractorviewmodel.id; newscComponents.subcontractor_name = subcontractorviewmodel.subcontractor_name; newscComponents.component_id = subcontractorviewmodel.scomponentslist[i].component_id; newscComponents.component_name = subcontractorviewmodel.scomponentslist[i].component_name; _scComponentsRepository.Add(newscComponents); } _unitOfWork.Commit(); response = request.CreateResponse(HttpStatusCode.OK); } return response; })); }
public SubContractor() { InitializeComponent(); _SCVM = new SubContractorViewModel(); this.DataContext = _SCVM; }
public JsonResult _AddSubContractorF(SubContractorViewModel subcontractorviewmodel) { if (ModelState.IsValid) { // Set Record Info string UserNameInit = @User.Identity.Name.ToString(); DateTime CreatedInit = DateTime.Now; var userid = (from x in db.AspNetUsers where x.UserName == UserNameInit select x).FirstOrDefault(); if (subcontractorviewmodel.SubContractorID != null) { // Update SubContractor SubContractor subcontractor = db.SubContractors.Single(x => x.SubContractorID == subcontractorviewmodel.SubContractorID); subcontractor.SubContractorName = subcontractorviewmodel.SubContractorName; subcontractor.Active = subcontractorviewmodel.Active; subcontractor.Address = subcontractorviewmodel.Address; subcontractor.CityBinID = subcontractorviewmodel.CityBinID; subcontractor.StateBinID = subcontractorviewmodel.StateBinID; subcontractor.ZipCode = subcontractorviewmodel.ZipCode; subcontractor.CountyBinID = subcontractorviewmodel.CountyBinID; subcontractor.DateUpdated = CreatedInit; subcontractor.UpdatedBy = UserNameInit; db.SaveChanges(); return(Json(new { Status = "Success", Modified = subcontractorviewmodel.SubContractorID }, JsonRequestBehavior.AllowGet)); } else { // Create SubContractor SubContractor sc = new SubContractor { SubContractorName = subcontractorviewmodel.SubContractorName, Active = subcontractorviewmodel.Active, Address = subcontractorviewmodel.Address, CityBinID = subcontractorviewmodel.CityBinID, StateBinID = subcontractorviewmodel.StateBinID, ZipCode = subcontractorviewmodel.ZipCode, CountyBinID = subcontractorviewmodel.CountyBinID, DateUpdated = CreatedInit, UpdatedBy = UserNameInit }; try { db.SubContractors.Add(sc); db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Debug.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } // SubContractor ID var SCID = sc.SubContractorID; if (subcontractorviewmodel.CancerTypeName != null) { // Cancer Types var stringToSplitA = subcontractorviewmodel.CancerTypeName; var queryA = from valA in stringToSplitA.Split(',') select Convert.ToInt32(valA); foreach (int valA in queryA) { // Add to AgencyContactClinics SubContractorClinics subcontractorclinics = new SubContractorClinics { SubContractorID = SCID, SiteID = subcontractorviewmodel.SiteID, ClinicID = Convert.ToInt32(subcontractorviewmodel.SiteID), ProgramID = Convert.ToInt32(subcontractorviewmodel.ProgramID), CancerTypeBinID = valA, IsClinic = false }; db.SubContractorClinics.Add(subcontractorclinics); db.SaveChanges(); } } return(Json(new { Status = "Success", Modified = subcontractorviewmodel.SubContractorID }, JsonRequestBehavior.AllowGet)); } } return(Json(new { Status = "Success" }, JsonRequestBehavior.AllowGet)); }