public JsonResult UpdateContractor(NewContractor model)
{
Contractor objC = new Contractor
{
Id = model.ASPNETUSERID,
CompanyName = model.CName,
Address = model.CAddress,
City = model.CCity,
State = model.CState,
Zipcode = model.CZipcode,
Phone = model.CMainPhone,
ContactName = model.PName,
ContractPhone = model.PPhone,
Comments = model.Comments,
Email = model.Email,
SendNewPass = model.SendNewPassword,
CategoryName = model.CatName,
BuildingID = model.BuildingID
};
db.Contractor.Attach(objC);
var Entry = db.Entry(objC);
Entry.Property(c => c.CategoryName).IsModified = true;
Entry.Property(c => c.Address).IsModified = true;
Entry.Property(c => c.State).IsModified = true;
Entry.Property(c => c.Zipcode).IsModified = true;
Entry.Property(c => c.Phone).IsModified = true;
Entry.Property(c => c.ContactName).IsModified = true;
Entry.Property(c => c.ContractPhone).IsModified = true;
Entry.Property(c => c.Email).IsModified = true;
Entry.Property(c => c.CategoryName).IsModified = true;
db.SaveChanges();
var objList = db.Contractor.Where(c => c.BuildingID == model.BuildingID).Select(c => new
{
ID = c.Id,
CompanyName = c.CompanyName,
Address = c.Address,
City = c.City,
State = c.State,
Zipcode = c.Zipcode,
Phone = c.Phone,
ContactName = c.ContactName,
ContactPhone = c.ContractPhone,
Comments = c.Comments,
Email = c.Email,
SendNewPassword = c.SendNewPass,
Category = c.CategoryName,
BuildingID = c.BuildingID
}).ToList();
var JSONdATA = Json(objList);
return new JsonResult { Data = JSONdATA, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult InsertNewContractor(NewContractor model)
{
//1)creat aspnetuserID
string password = PasswordGenerator.GeneratePassword("8").ToString();
//2) insert user
var UserID = RegisterUsers.InsertUser(model.Email, model.CMainPhone, password);
//3) insert User Role Contractor
var result = RegisterUsers.InserToRole("Contractor", UserID);
//4) add Contractor
//Transfer
Contractor objC = new Contractor
{
Id = UserID,
CompanyName = model.CName,
Address = model.CAddress,
City = model.CCity,
State = model.CState,
Zipcode = model.CZipcode,
Phone = model.CMainPhone,
ContactName = model.PName,
ContractPhone = model.PPhone,
Comments = model.Comments,
Email = model.Email,
SendNewPass = model.SendNewPassword,
CategoryName = model.CatName,
BuildingID = model.BuildingID
};
db.Contractor.Add(objC);
db.SaveChanges();
var objList = db.Contractor.Where(c=>c.BuildingID == objC.BuildingID).Select(c => new {
ID = c.Id,
CompanyName = c.CompanyName,
Address = c.Address,
City = c.City,
State = c.State,
Zipcode = c.Zipcode,
Phone = c.Phone,
ContactName = c.ContactName,
ContactPhone = c.ContractPhone,
Comments = c.Comments,
Email = c.Email,
SendNewPassword = c.SendNewPass,
Category = c.CategoryName,
BuildingID = c.BuildingID
}).ToList();
var JSONdATA = Json(objList);
return new JsonResult { Data = JSONdATA, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}