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