public IHttpActionResult PuttblComapnyDetail(int id, tblCompanyDetail tblComapnyDetail) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} if (id != tblComapnyDetail.CompanyID) { return(BadRequest()); } db.Entry(tblComapnyDetail).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblComapnyDetailExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public int DeleteCompany(int id) { tblCompanyDetail company = _db.tblCompanyDetails.Where(u => u.Id == id).FirstOrDefault(); company.IsDeleted = true; //_db.tblCompanyDetails.Remove(company); return(_db.SaveChanges()); }
public IHttpActionResult GettblComapnyDetail(int id) { tblCompanyDetail tblComapnyDetail = db.tblCompanyDetails.Find(id); if (tblComapnyDetail == null) { return(NotFound()); } return(Ok(tblComapnyDetail)); }
public int UpdateCompany(BOCompany model) { tblCompanyDetail company = _db.tblCompanyDetails.Where(u => u.Id == model.Id).FirstOrDefault(); company.Name = model.Name; company.Phone = model.Phone; company.Address = model.Address; company.Photo = model.Photo; company.Email = model.Email; company.Description = model.Description; return(_db.SaveChanges()); }
public IHttpActionResult DeletetblComapnyDetail(int id) { tblCompanyDetail tblComapnyDetail = db.tblCompanyDetails.Find(id); if (tblComapnyDetail == null) { return(NotFound()); } db.tblCompanyDetails.Remove(tblComapnyDetail); db.SaveChanges(); return(Ok(tblComapnyDetail)); }
public IHttpActionResult PosttblComapnyDetail(tblCompanyDetail tblComapnyDetail1) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} try { db.tblCompanyDetails.Add(tblComapnyDetail1); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tblComapnyDetail1.CompanyID }, tblComapnyDetail1)); } catch (System.Data.Entity.Validation.DbEntityValidationException err) { throw err; } }
public BOCompany GetCompanyById(int id) { tblCompanyDetail model = _db.tblCompanyDetails.Where(u => u.Id == id).FirstOrDefault(); BOCompany company = new BOCompany(); company.Name = model.Name; company.Phone = model.Phone; company.Address = model.Address; company.UserId = model.UserId; company.Photo = model.Photo; company.Email = model.Email; company.Description = model.Description; return(company); }
public int CreateCompany(BOCompany model) { tblCompanyDetail company = new tblCompanyDetail(); company.Name = model.Name; company.Phone = model.Phone; company.Address = model.Address; company.UserId = model.UserId; company.IsDeleted = false; company.Photo = model.Photo; company.Email = model.Email; company.Description = model.Description; company.CreatedAt = DateTime.Now.ToString(); _db.tblCompanyDetails.Add(company); return(_db.SaveChanges()); }
protected void btnSubmit_Click(object sender, EventArgs e) { tblCompanyDetail companydetail = new tblCompanyDetail(); int userid = Convert.ToInt32(Session["userid"]); int companytypeid = Convert.ToInt32(Session["companytypeid"]); int systemid = Convert.ToInt32(ddlSystem.SelectedValue); int subsystemid = Convert.ToInt32(ddlSubSystem.SelectedValue); string systemtitle = ddlSystem.SelectedItem.ToString(); string subsystemtitle = ddlSubSystem.SelectedItem.ToString(); if (db.tblCompanyDetails.Any (d => d.UserId == userid && d.SystemId == systemid && d.SubSystemId == subsystemid && d.SystemTitle == systemtitle && d.SubSystemTitle == subsystemtitle ) ) { Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + "Data already exists!" + "');", true); } else { companydetail.UserId = Convert.ToInt32(Session["userid"]); companydetail.CompanyTypeId = companytypeid; companydetail.SystemId = Convert.ToInt32(ddlSystem.SelectedValue); companydetail.SystemTitle = ddlSystem.SelectedItem.ToString(); if (ddlSubSystem.SelectedValue == "0") { companydetail.SubSystemId = Convert.ToInt32(0); companydetail.SubSystemTitle = "N/A"; } else { companydetail.SubSystemId = Convert.ToInt32(ddlSubSystem.SelectedValue); companydetail.SubSystemTitle = ddlSubSystem.SelectedItem.ToString(); } db.tblCompanyDetails.Add(companydetail); db.SaveChanges(); Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Added successfully');", true); } }
protected void btnUpdate_Click(object sender, EventArgs e) { tblCompanyDetail companydetail = new tblCompanyDetail(); int id = Convert.ToInt32(Session["id"]); var data = db.tblSystems.Where(d => d.Id == id).FirstOrDefault(); data.Title = txtTitle.Text; db.SaveChanges(); foreach (var item in db.tblCompanyDetails.Where(d => d.SystemId == data.Id).ToList()) { item.SystemTitle = data.Title; } db.SaveChanges(); Response.Redirect(Request.RawUrl); Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Data Updated!');", true); }
public IHttpActionResult PosttblCompanyDetail(tblCompanyDetail tblCompanyDetail) { db.tblCompanyDetails.Add(tblCompanyDetail); try { db.SaveChanges(); } catch (DbUpdateException) { if (tblCompanyDetailExists(tblCompanyDetail.CompanyID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tblCompanyDetail.CompanyID }, tblCompanyDetail)); }
protected void btnSubmit_Click(object sender, EventArgs e) { tblCompanyDetail companydetail = new tblCompanyDetail(); int userid = Convert.ToInt32(Session["userid"]); int companytypeid = Convert.ToInt32(Session["companytypeid"]); int systemid = Convert.ToInt32(ddlSystem.SelectedValue); int subsystemid = Convert.ToInt32(ddlSubSystem.SelectedValue); //int itemid = Convert.ToInt32(ddlItem.SelectedValue); //int subitemid = Convert.ToInt32(ddlSubItem.SelectedValue); string systemtitle = ddlSystem.SelectedItem.ToString(); string subsystemtitle = ddlSubSystem.SelectedItem.ToString(); //string itemtitle = ddlItem.SelectedItem.ToString(); //string subitemtitle = ddlSubItem.SelectedItem.ToString(); if (db.tblCompanyDetails.Any (d => d.UserId == userid && d.BrandName == txtBrand.Text && d.MinCapacity == txtMinCapacity.Text && d.MaxCapacity == txtMaxCapacity.Text && d.SystemId == systemid && d.SubSystemId == subsystemid && //d.ItemId == itemid && //d.SubItemId == subitemid && d.SystemTitle == systemtitle && d.SubSystemTitle == subsystemtitle //&& //d.ItemTitle == itemtitle && //d.SubItemTitle == subitemtitle ) ) { Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + "Data already exists!" + "');", true); } else { companydetail.UserId = Convert.ToInt32(Session["userid"]); companydetail.CompanyTypeId = companytypeid; if (txtBrand.Text == "") { companydetail.BrandName = "N/A"; } else { companydetail.BrandName = txtBrand.Text; } if (txtMinCapacity.Text == "") { companydetail.MinCapacity = "N/A"; } else { companydetail.MinCapacity = txtMinCapacity.Text; } if (txtMaxCapacity.Text == "") { companydetail.MaxCapacity = "N/A"; } else { companydetail.MaxCapacity = txtMaxCapacity.Text; } companydetail.SystemId = Convert.ToInt32(ddlSystem.SelectedValue); companydetail.SystemTitle = ddlSystem.SelectedItem.ToString(); if (ddlSubSystem.SelectedValue == "0") { companydetail.SubSystemId = Convert.ToInt32(0); companydetail.SubSystemTitle = "N/A"; } else { companydetail.SubSystemId = Convert.ToInt32(ddlSubSystem.SelectedValue); companydetail.SubSystemTitle = ddlSubSystem.SelectedItem.ToString(); } if (ddlItem.SelectedValue == "0") { companydetail.ItemId = Convert.ToInt32(0); companydetail.ItemTitle = "N/A"; } else { companydetail.ItemId = Convert.ToInt32(ddlItem.SelectedValue); companydetail.ItemTitle = ddlItem.SelectedItem.ToString(); } if (ddlSubItem.SelectedValue == "0") { companydetail.SubItemId = Convert.ToInt32(0); companydetail.SubItemTitle = "N/A"; } else { companydetail.SubItemId = Convert.ToInt32(ddlSubItem.SelectedValue); companydetail.SubItemTitle = ddlSubItem.SelectedItem.ToString(); } //string Catalogue = Session["companyName"] + "_" + ddlSystem.SelectedItem + // "_" + ddlSubSystem.SelectedItem + "_" + ddlItem.SelectedItem + // "_" + ddlSubItem.SelectedItem + "_" + txtBrand.Text + "_" + "Catalogue"; if (fupCatalogue.HasFile) { //string extension = Path.GetExtension(fupCatalogue.PostedFile.FileName); //companydetail.Catalogue = extension; //fupCatalogue.SaveAs(Server.MapPath("../UploadedFiles/" + fupCatalogue.FileName + extension)); string fileNameCatalogue = fupCatalogue.FileName.Replace(",", ""); companydetail.Catalogue = fileNameCatalogue; fupCatalogue.SaveAs(Server.MapPath("../UploadedFiles/" + fileNameCatalogue)); } //string Specification = Session["companyName"] + "_" + ddlSystem.SelectedItem + // "_" + ddlSubSystem.SelectedItem + "_" + ddlItem.SelectedItem + // "_" + ddlSubItem.SelectedItem + "_" + txtBrand.Text + "_" + "Specification"; if (fupSpecification.HasFile) { //string extension = Path.GetExtension(fupSpecification.PostedFile.FileName); //companydetail.Specification = extension; //fupSpecification.SaveAs(Server.MapPath("../UploadedFiles/" + fupSpecification.FileName + extension)); string fileNameSpecification = fupSpecification.FileName.Replace(",", ""); companydetail.Specification = fileNameSpecification; fupSpecification.SaveAs(Server.MapPath("../UploadedFiles/" + fileNameSpecification)); } db.tblCompanyDetails.Add(companydetail); db.SaveChanges(); Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Added successfully');", true); } }