public HttpResponseMessage GetCompanyUpdate([FromBody] clsCompanyInsert objclsCompanyInsert)
{
DbContextTransaction transaction = db.Database.BeginTransaction();
try
{
var longin = (from comp in db.companies
where (comp.company_id == objclsCompanyInsert.company_id)
select comp).SingleOrDefault();
var longin_table = (from comp in db.logins
where (comp.company_id == objclsCompanyInsert.company_id)
select comp).SingleOrDefault();
if (longin != null)
{
longin.name = objclsCompanyInsert.name;
longin.username = objclsCompanyInsert.username;
longin.password = objclsCompanyInsert.password;
longin.email = objclsCompanyInsert.email;
longin.phone = objclsCompanyInsert.phone;
db.SaveChanges();
longin_table.username = objclsCompanyInsert.username;
longin_table.password = objclsCompanyInsert.password.GetMD5HashData();
longin_table.email = objclsCompanyInsert.email;
db.SaveChanges();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.OK, "Updated"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Not Found"));
}
}
catch (Exception ex)
{
transaction.Rollback();
var message = Request.CreateResponse(HttpStatusCode.InternalServerError);
return(message);
}
}
public HttpResponseMessage GetCompanyInsert([FromBody] clsCompanyInsert objclsCompanyInsert)
{
DbContextTransaction transaction = db.Database.BeginTransaction();
try
{
var longin = (from comp in db.companies
where (comp.email == objclsCompanyInsert.email)
select comp).SingleOrDefault();
var longin2 = (from comp in db.companies
where (comp.username == objclsCompanyInsert.username)
select comp).SingleOrDefault();
string userfoundstring = "";
if (longin != null)
{
userfoundstring = "E-mail Already Exist";
}
else if (longin2 != null)
{
userfoundstring = "User Name Already Exist";
}
if (userfoundstring == "")
{
DateTime today = DateTime.Today;
company objcompany = new company();
objcompany.name = objclsCompanyInsert.name;
objcompany.username = objclsCompanyInsert.username;
objcompany.password = objclsCompanyInsert.password;
objcompany.email = objclsCompanyInsert.email;
objcompany.phone = objclsCompanyInsert.phone;
objcompany.type = "Company";
db.companies.Add(objcompany);
db.SaveChanges();
int company_id = objcompany.company_id;
login objlogin = new login();
objlogin.username = objclsCompanyInsert.username;
objlogin.password = objclsCompanyInsert.password.GetMD5HashData();
objlogin.email = objclsCompanyInsert.email;
objlogin.role_id = 2;
objlogin.date = today;
objlogin.company_id = company_id;
db.logins.Add(objlogin);
db.SaveChanges();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.OK, "Created"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Found, userfoundstring));
}
}
catch (Exception ex)
{
transaction.Rollback();
var message = Request.CreateResponse(HttpStatusCode.InternalServerError);
return(message);
}
}
