public CompanySite Update(CompanySite CompanySite)
{
var sqlQuery =
"UPDATE CompanySite " +
"SET IDCOMPANYSITE = @IDCOMPANYSITE, " +
" COMPANYSITENAME = @COMPANYSITENAME, " +
" LOCATION = @LOCATION, " +
" ADDRESS1 = @ADDRESS1, " +
" ADDRESS2 = @ADDRESS2, " +
" COUNTRY = @COUNTRY, " +
" PROVINCE = @PROVINCE, " +
" CITY = @CITY, " +
" TELEPHONE1 = @TELEPHONE1, " +
" TELEPHONE2 = @TELEPHONE2, " +
" FAX1 = @FAX1, " +
" FAX2 = @FAX2, " +
" EMAIL = @EMAIL, " +
" LOGO = @LOGO, " +
" WEBSITE = @WEBSITE, " +
" POSCODE = @POSCODE, " +
" UPDATEBY = @UPDATEBY, " +
" UPDATEDATE = @UPDATEDATE " +
" WHERE SID = @SID";
this._db.Execute(sqlQuery, CompanySite);
return(CompanySite);
}
public CompanySite Add(CompanySite CS)
{
var sqlQuery = "INSERT INTO CompanySite (IDCOMPANYSITE, COMPANYSITENAME, COMPANY, REGION, LOCATION, ADDRESS1, ADDRESS2, COUNTRY, PROVINCE, CITY, TELEPHONE1, TELEPHONE2, FAX1, FAX2, EMAIL, WEBSITE, POSCODE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES(@IDCOMPANYSITE, @COMPANYSITENAME, @COMPANY, @REGION, @LOCATION, @ADDRESS1, @ADDRESS2, @COUNTRY, @PROVINCE, @CITY, @TELEPHONE1, @TELEPHONE2, @FAX1, @FAX2, @EMAIL, @WEBSITE, @POSCODE, @INPUTBY, @INPUTDATE, @UPDATEBY, @UPDATEDATE); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var SID = _db.Query <int>(sqlQuery, CS).Single();
CS.SID = SID;
return(CS);
}
public ActionResult Edit(CompanySite companysite, int id)
{
if (ModelState.IsValid)
{
companysite.UPDATEBY = int.Parse(Session["userid"].ToString());
companysite.UPDATEDATE = DateTime.Now;
CS.Update(companysite);
}
return(RedirectToAction("Edit", "Company", new { id = companysite.COMPANY }));
}
//
// GET: /CompanySite/Create
public ActionResult Create(int Company)
{
//ViewData["Company"] = Company;
var comp = CP.Find(Company);
//ViewData["CompanyName"] = comp.COMPANYNAME;
var model = new CompanySite();
model.COMPANY = Company;
model.COMPANYNAME = comp.COMPANYNAME;
model.GetSelectListRegion = GetSelectListRegion();
model.GetSelectListLocation = GetSelectListLocation();
model.GetSelectListCountry = GetSelectListCountry();
model.GetSelectListProvince = GetSelectListProvince();
model.GetSelectListCity = GetSelectListCity();
return(View(model));
}
public ActionResult Create(CompanySite companysite)
{
if (ModelState.IsValid)
{
companysite.INPUTBY = int.Parse(Session["userid"].ToString());
companysite.INPUTDATE = DateTime.Now;
companysite.REGION = 1;
CS.Add(companysite);
return(RedirectToAction("Edit", "Company", new { id = companysite.COMPANY }));
}
else
{
companysite.GetSelectListRegion = GetSelectListRegion();
companysite.GetSelectListLocation = GetSelectListLocation();
companysite.GetSelectListCountry = GetSelectListCountry();
companysite.GetSelectListProvince = GetSelectListProvince();
companysite.GetSelectListCity = GetSelectListCity();
return(View(companysite));
}
}
public IHttpActionResult CreateCompanySite(CompanySiteModel model)
{
try
{
if (ModelState.IsValid)
{
var companysite = db.CompanySites.FirstOrDefault(s => s.SiteName == model.SiteName);
if (companysite == null)
{
var addcompanysite = new CompanySite();
addcompanysite.SiteName = model.SiteName;
addcompanysite.Address = model.Address;
addcompanysite.City = model.City;
addcompanysite.State = model.State;
addcompanysite.PostalCode = model.PostalCode;
addcompanysite.Phone = model.Phone;
addcompanysite.Website = model.Website;
addcompanysite.ContactName = model.ContactName;
addcompanysite.EmailAddress = model.EmailAddress;
addcompanysite.PhoneNumber = model.PhoneNumber;
addcompanysite.CompanyId = model.CompanyId;
db.CompanySites.Add(addcompanysite);
db.SaveChanges();
return(Ok(addcompanysite));
}
else
{
return(Ok("Site Name Already Exists"));
}
}
else
{
return(Ok("Fill All the Mandatory Fields"));
}
}
catch (Exception ex)
{
return(Ok("" + ex.Message + ""));
}
}
