public SubContractor Insert(SubContractor objSubContractor) { using (IDbConnection connection = OpenConnection(dataConnection)) { var result = new SubContractor(); IDbTransaction trn = connection.BeginTransaction(); string sql = @"INSERT INTO SubContractor(SubRefNo,SubName,ContactPerson,Designation,OfficeNo,MobileNo,Email, Address1,Address2,Address3,Address4,CreatedBy,CreatedDate,OrganizationId) VALUES(@SubRefNo,@SubName,@ContactPerson,@Designation,@OfficeNo,@MobileNo,@Email,@Address1, @Address2,@Address3,@Address4,@CreatedBy,@CreatedDate,@OrganizationId); SELECT CAST(SCOPE_IDENTITY() as int)"; try { int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(SubContractor).Name, "0", 1); objSubContractor.SubRefNo = internalid.ToString(); int id = connection.Query <int>(sql, objSubContractor, trn).Single(); objSubContractor.SubContractorId = id; InsertLoginHistory(dataConnection, objSubContractor.CreatedBy, "Create", "Subcontractor", id.ToString(), "0"); trn.Commit(); } catch (Exception ex) { trn.Rollback(); objSubContractor.SubContractorId = 0; objSubContractor.SubRefNo = null; } return(objSubContractor); } }
public string UpdateSubContractor(SubContractor model) { using (IDbConnection connection = OpenConnection(dataConnection)) { IDbTransaction txn = connection.BeginTransaction(); try { string query = @"Update SubContractor Set SubRefNo=@SubRefNo,SubName=@SubName,ContactPerson=@ContactPerson, Designation=@Designation,OfficeNo=@OfficeNo,MobileNo=@MobileNo,Email=@Email,Address1=@Address1, Address2=@Address2,Address3=@Address3,Address4=@Address4, CreatedBy=@CreatedBy,CreatedDate=@CreatedDate,OrganizationId=@OrganizationId OUTPUT INSERTED.SubContractorId WHERE SubContractorId=@SubContractorId"; string ref_no = connection.Query <string>(query, model, txn).First(); InsertLoginHistory(dataConnection, model.CreatedBy, "Modify", "Subcontractor", ref_no.ToString(), "0"); txn.Commit(); return(ref_no); } catch (Exception ex) { txn.Rollback(); throw ex; } } }
public void Put(long id, SubContractor data) { if (keyHandler.CheckApiKey(this.Request)) { mapper.UpdateSubContractor(id, data); } }
public ResponseMessage CreateVendor(AddVendor vendor) { try { if (_context.SubContractor.Where(x => x.Name == vendor.Name && x.IsDelete == false).Count() > 0) { throw new ValueNotFoundException("Vendor Name already exist."); } ResponseMessage responseMessage = new ResponseMessage(); SubContractor sc = _mapper.Map <SubContractor> (vendor); sc.CreatedAt = DateTime.Now; sc.CreatedBy = 1; //TODO _context.SubContractor.Add(sc); _context.SaveChanges(); //Add the sub contractor service type if (vendor.VendorServiceTypeDetails.Any()) { foreach (var item in vendor.VendorServiceTypeDetails) { SubContractorServiceType subContractorServiceType = new SubContractorServiceType(); subContractorServiceType.SubcontId = vendor.Id; subContractorServiceType.ServicetypeId = item.ServiceTypeId; _context.SubContractorServiceType.Add(subContractorServiceType); } } responseMessage.Message = "Vendor created sucessfully"; return(responseMessage); } catch (Exception ex) { throw ex; } }
public List <SubContractor> SearchByType(int id) { using (var conn = Connection) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = @" SELECT sc.Id AS SubId, sc.SubContractorBusinessName, sc.SubContractorImageUrl FROM SubContractor sc LEFT JOIN SubContractorJobType jt ON jt.SubContractorId = sc.Id LEFT JOIN SubContractorType st ON jt.SubContractorTypeId = st.Id WHERE st.Id = @id "; DbUtilities.AddParameter(cmd, "@id", id); var reader = cmd.ExecuteReader(); var subsOfType = new List <SubContractor>(); while (reader.Read()) { var sub = new SubContractor() { Id = DbUtilities.GetInt(reader, "SubId"), SubcontractorBusinessName = DbUtilities.GetString(reader, "SubContractorBusinessName"), SubContractorImageLocation = DbUtilities.GetString(reader, "SubContractorImageUrl") }; subsOfType.Add(sub); } reader.Close(); return(subsOfType); } } }
public SubContractor Get(int id) { using (var db = DBConnection.GetConnection()) { return(SubContractor.GetById <SubContractor>(db, id)); } }
public bool Delete(SubContractor c) { using (var db = DBConnection.GetConnection()) { return(SubContractor.Delete <SubContractor>(db, c)); } }
public SubContractor Get(long ID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@SubContractorID", ID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_SubContractor_By_ID", paramList); SubContractor obj = new SubContractor(); obj.SubAddress = Convert.ToString(dt.Rows[0]["SubAddress"]); obj.SubCode = Convert.ToString(dt.Rows[0]["SubCode"]); obj.SubContactPerson = Convert.ToString(dt.Rows[0]["SubContactPerson"]); obj.SubContractorID = Convert.ToInt64(dt.Rows[0]["SubContractorID"]); obj.SubEmail = Convert.ToString(dt.Rows[0]["SubEmail"]); obj.SubFax = Convert.ToString(dt.Rows[0]["SubFax"]); obj.SubMobile = Convert.ToString(dt.Rows[0]["SubMobile"]); obj.SubName = Convert.ToString(dt.Rows[0]["SubName"]); obj.SubPhone = Convert.ToString(dt.Rows[0]["SubPhone"]); obj.SubStatus = Convert.ToBoolean(dt.Rows[0]["SubStatus"]); return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public bool Post([FromBody] SubContractor c) { using (var db = DBConnection.GetConnection()) { return(SubContractor.Persist <SubContractor>(db, c)); } }
public HttpResponseMessage InsertSubContractor(SubContractor subContractor) { subContractor.Id = Guid.NewGuid(); var result = _subContractorService.InsertSubContractor(subContractor); return(toJson(null, OperatingState.Success, result ? "添加成功" : "添加失败")); }
public IEnumerable <SubContractor> Get() { using (var db = DBConnection.GetConnection()) { return(SubContractor.GetAll <SubContractor>(db)); } }
public ActionResult Create(SubContractor model) { model.CreatedBy = UserID.ToString(); model.CreatedDate = System.DateTime.Now; model.OrganizationId = OrganizationId; var repo = new SubContractorRepository(); bool isexists = repo.IsFieldExists(repo.ConnectionString(), "SubContractor", "SubName", model.SubName, null, null); if (!isexists) { var result = new SubContractorRepository().Insert(model); if (result.SubContractorId > 0) { TempData["Success"] = "Added Successfully!"; TempData["SubRefNo"] = result.SubRefNo; return(RedirectToAction("Create")); } else { TempData["error"] = "Oops!!..Something Went Wrong!!"; TempData["SubRefNo"] = null; return(View("Create", model)); } } else { TempData["error"] = "This Name Alredy Exists!!"; TempData["SubRefNo"] = null; return(View("Create", model)); } }
public void Post(SubContractor data) { if (keyHandler.CheckApiKey(this.Request)) { mapper.CreateSubContractor(data); } }
public ActionResult Create(SubContractorFormViewModel viewModel) { if (!ModelState.IsValid) { return(View("SubContractorForm", viewModel)); } var contractor = new SubContractor { SubcontractorId = Guid.NewGuid(), AdministratorId = User.Identity.GetUserId(), Region = viewModel.Region, AffiliateRegion = viewModel.AffiliateRegion, OrgName = viewModel.OrgName, Director = viewModel.Director, City = viewModel.City, State = viewModel.State, County = viewModel.County, ZipCode = viewModel.ZipCode, EIN = viewModel.EIN, Address1 = viewModel.Address1, PoBox = viewModel.PoBox, Active = viewModel.Active, SubmittedDate = DateTime.Now }; db.SubContractors.Add(contractor); db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public SubContractor GetById(int id) { using (var conn = Connection) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = @" SELECT Id as SubId, UserProfileId, SubContractorBusinessName, SubContractorImageUrl FROM SubContractor WHERE Id = @id "; DbUtilities.AddParameter(cmd, "@id", id); var reader = cmd.ExecuteReader(); SubContractor subContractor = null; if (reader.Read()) { subContractor = DbModelBuilder.BuildSubContractorModel(reader); } reader.Close(); return(subContractor); } } }
private void btnSave_Click(object sender, EventArgs e) { try { if (objSubContractor == null) { objSubContractor = new SubContractor(); } objSubContractor.SubAddress = txtAddress.Text; objSubContractor.SubCode = txtCode.Text; objSubContractor.SubContactPerson = txtContactPerson.Text; objSubContractor.SubEmail = txtEmail.Text; objSubContractor.SubFax = txtFax.Text; objSubContractor.SubMobile = txtMobile.Text; objSubContractor.SubName = txtName.Text; objSubContractor.SubPhone = txtPhone.Text; objSubContractor.SubStatus = true; long ID = objSubContractor_DL.Add(objSubContractor); if (ID > 0) { MessageBox.Show(this, "Successfuly Saved", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Warning); bindSub.DataSource = objSubContractor_DL.GetView(); Clear(); } } catch (Exception ex) { MessageBox.Show(this, "Error occured while saving", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void gvSubContractors_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex >= 0) { long ID = Convert.ToInt64(gvSubContractors.Rows[e.RowIndex].Cells["ColID"].Value); objSubContractor = objSubContractor_DL.Get(ID); if (objSubContractor != null) { txtPhone.Text = objSubContractor.SubPhone; txtName.Text = objSubContractor.SubName; txtMobile.Text = objSubContractor.SubMobile; txtFax.Text = objSubContractor.SubFax; txtEmail.Text = objSubContractor.SubEmail; txtContactPerson.Text = objSubContractor.SubContactPerson; txtCode.Text = objSubContractor.SubCode; txtAddress.Text = objSubContractor.SubAddress; lblID.Text = objSubContractor.SubContractorID.ToString(); btnDelete.Enabled = true; } } } catch (Exception) { MessageBox.Show(this, "Error occured while loading Sub Contractor details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public ActionResult Create() { ViewBag.Title = "Create"; SubContractor SubContractor = new SubContractor(); SubContractor.SubRefNo = new SubContractorRepository().GetRefNo(SubContractor); return(View(SubContractor)); }
public ActionResult DeleteConfirmed(int id) { SubContractor subContractor = db.SubContractors.Find(id); db.SubContractors.Remove(subContractor); db.SaveChanges(); return(RedirectToAction("Index")); }
public List <SubContractor> UpdateSubContractorDetailsAsync(SubContractor sc, List <SubContractorSkillSetMapping> scSkillSets) { if (myconn.State != ConnectionState.Open) { myconn.Open(); } SqlTransaction tran = myconn.BeginTransaction(); sc.createdDate = DateTime.Now; sc.modifiedDate = DateTime.Now; SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "SP_SubContractorInsertUpdate"; sqlCmd.Parameters.Add(new SqlParameter("@mode", "U")); sqlCmd.Parameters.Add(new SqlParameter("@Id", sc.Id)); sqlCmd.Parameters.Add(new SqlParameter("@subconName", sc.subconName)); sqlCmd.Parameters.Add(new SqlParameter("@email", sc.email)); sqlCmd.Parameters.Add(new SqlParameter("@address", sc.address)); sqlCmd.Parameters.Add(new SqlParameter("@phoneNumber", sc.phoneNumber)); sqlCmd.Parameters.Add(new SqlParameter("@statusId", sc.statusId)); sqlCmd.Parameters.Add(new SqlParameter("@createdDate", sc.createdDate)); sqlCmd.Parameters.Add(new SqlParameter("@modifiedDate", sc.modifiedDate)); sqlCmd.Parameters.Add(new SqlParameter("@userId", sc.userId)); try { sqlCmd.Connection = myconn; sqlCmd.Transaction = tran; sqlCmd.ExecuteNonQuery(); if (scSkillSets != null) { foreach (SubContractorSkillSetMapping item in scSkillSets) { UpdateSubContractorSkillSetsDetailsAsync(item, sc.Id, tran); } } tran.Commit(); } catch (Exception ex) { tran.Rollback(); gs.LogData(ex); throw ex; } finally { if (myconn.State != ConnectionState.Closed) { myconn.Close(); } } return(GetSubContractorDetailsAsync(0, 'I')); }
public HttpResponseMessage Insert([FromBody] SubContractor sc) { _SubContractorRepo.InsertSubContractorDetailsAsync(sc, sc.skillSelect); var message = Request.CreateResponse(HttpStatusCode.Created, sc); message.Headers.Location = new Uri(Request.RequestUri + sc.Id.ToString()); return(message); }
public ActionResult Update(long id) { if (HttpContext.User.Identity.IsAuthenticated) { SubContractor sc = mapper.GetSubContractor(id); return(View(sc)); } return(RedirectToAction("LoginPage", "Connection")); }
public IActionResult NewSubcontractor(SubContractor subContractor) { var currentUser = GetCurrentUserProfile(); subContractor.UserProfileId = currentUser.Id; _subcontractorRepository.AddSubcontractor(subContractor); return(Ok(CreatedAtAction("Get", new { id = subContractor.Id }, subContractor))); }
/// <summary> /// Insert the SubContractor /// </summary> /// <param name="subContractor"></param> /// <returns></returns> public bool InsertSubContractor(SubContractor subContractor) { if (subContractor == null) { throw new ArgumentNullException("subContractor is null"); } bool result = _subContractorRepository.Insert(subContractor); return(result); }
/// <summary> /// Updates the SubContractor /// </summary> /// <param name="subContractor"></param> /// <returns></returns> public bool UpdateSubContractor(SubContractor subContractor) { if (subContractor == null) { throw new ArgumentNullException("subContractor is null"); } bool result = _subContractorRepository.SingleUpdate(subContractor); return(result); }
public ActionResult Edit([Bind(Include = "SubContractorID,LegacySubContractorCodeCCSP,LegacySubContractorCodeWWC,LegacySubContractorCodeCRCCP,SubContractorName,Address,CityBinID,StateBinID,ZipCode,ContactName,Phone,CountyBinID,Active,DateUpdated,UpdatedBy,DigitalMamIndicator,DigitalTechCode")] SubContractor subContractor) { if (ModelState.IsValid) { db.Entry(subContractor).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(subContractor)); }
/// <summary> /// Builds an instance of a SubContractor from a Sql Data Reader object /// </summary> /// <param name="reader"></param> /// <returns>Instance of a <strong>SubContractor</strong></returns> public static SubContractor BuildSubContractorModel(SqlDataReader reader) { var subcontractor = new SubContractor() { Id = DbUtilities.GetInt(reader, "SubId"), UserProfileId = DbUtilities.GetInt(reader, "UserProfileId"), SubcontractorBusinessName = DbUtilities.GetString(reader, "SubContractorBusinessName"), SubContractorImageLocation = DbUtilities.GetString(reader, "SubContractorImageUrl"), }; return(subcontractor); }
public async Task <IActionResult> Update([FromBody] SubContractor subcontractor) { try { _context.Entry(subcontractor).State = Microsoft.EntityFrameworkCore.EntityState.Modified; _context.SaveChanges(); return(Ok(subcontractor)); } catch (Exception e) { return(BadRequest(e)); } }
public async Task <IActionResult> Create([FromBody] SubContractor subcontractor) { try { _context.SubContractor.Add(subcontractor); _context.SaveChanges(); return(Ok(subcontractor)); } catch (Exception e) { return(BadRequest(e)); } }
private void Clear() { txtPhone.Text = ""; txtName.Text = ""; txtMobile.Text = ""; txtFax.Text = ""; txtEmail.Text = ""; txtContactPerson.Text = ""; txtCode.Text = ""; txtAddress.Text = ""; objSubContractor = null; lblID.Text = "[Auto]"; btnDelete.Enabled = false; }