public ActionResult Index(string jobsid)
{
if (jobsid != null && jobsid.Trim() != "")
{
var check_date = db.tb_jobs.Where(w => w.service_order_no == jobsid && w.is_delete == 0).FirstOrDefault();
if (check_date != null)
{
var engineer_data = (from e in db.tb_engineer where e.is_delete == 0 && check_date.engineer_id == e.id select e);
var store_data = db.tb_store.Where(w => w.id == engineer_data.FirstOrDefault().site_id&& w.is_delete == 0).FirstOrDefault();
if (Convert.ToDateTime(check_date.appointment_datetime).Date == DateTime.Today.Date && check_date.appointment_to_datetime != null && store_data != null)
{
var data = (from j in db.tb_jobs
where j.is_delete == 0 && j.service_order_no == jobsid
select new index
{
//phone_mobile = j.phone_mobile,
service_order_no = j.service_order_no,
appointment_datetime = j.appointment_datetime,
appointment_to_datetime = j.appointment_to_datetime,
customer_lat = j.customer_lat,
customer_long = j.customer_long,
customer_fullname = j.customer_fullname,
customer_mobile = j.phone_mobile,
status_job = j.status_job,
engi = engineer_data.FirstOrDefault(),
phone_office = store_data.tel1 != null ? store_data.tel1 : store_data.tel2 != null ? store_data.tel2 : store_data.tel3
}).FirstOrDefault();
if (data.status_job != 2 && data.status_job != 4)
{
ViewData["job_engi"] = data;
StandardController service_con = new StandardController();
string key_azure = service_con.GetKeyAzure();
ViewData["Key_Azure"] = key_azure;
//get IP , Stamp
var ip_client = byi_common.common.GetIPAddress();
check_date.ip_customer = ip_client;
check_date.date_customer = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, zone);
db.tb_jobs.AddOrUpdate(check_date);
db.SaveChanges();
return(View());
}
return(View("Error"));
}
return(View("Error"));
}
return(View("Error"));
}
return(View("Error"));
}
public ActionResult edit(string id)
{
GetDataFromDb();
Guid check_Guid;
bool isValid = Guid.TryParse(id, out check_Guid);
if (isValid)
{
Guid newGuid = Guid.Parse(id);
if (User.IsInRole("admin"))
{
var obj_list_en = (from e in db.tb_engineer
where e.en_guid == newGuid && e.is_delete == 0
select e).FirstOrDefault();
if (obj_list_en != null)
{
ViewData["Data"] = obj_list_en;
}
else
{
var url = ConfigurationManager.AppSettings["Base_URL"].ToString() + "engineer/all";
Response.Redirect(url);
}
}
else
{
var getName = User.Identity.Name;
var CheckUser = Membership.GetUser(getName).ProviderUserKey;
Guid convertGuid = new Guid(CheckUser.ToString());
var idStore = db.tb_mapping_store.Where(w => w.account_guid == convertGuid).Select(s => s.site_id).FirstOrDefault();
var obj_list_en = (from e in db.tb_engineer
where e.site_id == idStore && e.en_guid == newGuid && e.is_delete == 0
select e).FirstOrDefault();
if (obj_list_en != null)
{
ViewData["Data"] = obj_list_en;
}
else
{
//wait redirect
var url = ConfigurationManager.AppSettings["Base_URL"].ToString() + "engineer/all";
Response.Redirect(url);
}
}
}
else
{
var url = ConfigurationManager.AppSettings["Base_URL"].ToString() + "engineer/all";
Response.Redirect(url);
}
ViewData["Azure_Path"] = ConfigurationManager.AppSettings["Azure_url"];
StandardController service_con = new StandardController();
string key_azure = service_con.GetKeyAzure();
ViewData["Key_Azure"] = key_azure;
return(View());
}