public int PostDeletePatrolCar([FromBody] Patrolcars frm) { int ret = 0; string Qry = "update Patrolcars set delflag='1' where patrolid=" + frm.Patrolid; ret = DAL.PostGre_ExNonQry(Qry); return(ret); }
public int PostUpdatePatrolCar([FromBody] Patrolcars frm) { int ret = 0; string Qry = "update Patrolcars set AhwalID = " + frm.Ahwalid + ",platenumber = '" + frm.Platenumber + "',model = '" + frm.Model + "',typecode='" + frm.Typecode + "',defective = " + frm.Defective + ",rental = " + frm.Rental + ",barcode = '" + frm.Barcode + "',vinnumber='" + frm.Vinnumber + "' where patrolid=" + frm.Patrolid; ret = DAL.PostGre_ExNonQry(Qry); return(ret); }
public int PostAddPatrolCar([FromBody] Patrolcars frm) { int ret = 0; string Qry = "insert into Patrolcars(AhwalID,platenumber,model,typecode,defective,rental,barcode,vinnumber) values (" + frm.Ahwalid + ",'" + frm.Platenumber + "','" + frm.Model + "','" + frm.Typecode + "'," + frm.Defective + "," + frm.Rental + ",'" + frm.Barcode + "','" + frm.Vinnumber + "')"; ret = DAL.PostGre_ExNonQry(Qry); return(ret); }
public Patrolcars GetPatrolCardByID(Users u, Patrolcars p) { //first we have to check if this user is authorized to perform this transaction if (!_user.isAuthorized(u.Userid, p.Ahwalid, Handler_User.User_Role_Ahwal)) { return(null); //we dont need to log this since its just read operation } var result = _context.Patrolcars.FirstOrDefault <Patrolcars>(e => e.Patrolid == p.Patrolid); if (result != null) { return(result); } return(null); }
public Operationlogs CheckInPatrolAndHandHeld(Users u, Ahwalmapping m, Patrolcars p, Handhelds h) { try { //first we have to check if this user is authorized to perform this transaction //if (!_user.isAuthorized(u.Userid, p.Ahwalid, Handler_User.User_Role_Ahwal)) //{ // Operationlogs ol_failed = new Operationlogs(); // ol_failed.Userid = u.Userid; // ol_failed.Operationid = Handler_Operations.Opeartion_Mapping_CheckInPatrolAndHandHeld; // ol_failed.Statusid = Handler_Operations.Opeartion_Status_UnAuthorized; // ol_failed.Text = "المستخدم لايملك صلاحية هذه العمليه"; // _oper.Add_New_Operation_Log(ol_failed); // return ol_failed; //} //we have to check first that this person doesn't exists before in mapping var person_mapping_exists = _context.Ahwalmapping.FirstOrDefault <Ahwalmapping>(e => e.Ahwalmappingid.Equals(m.Ahwalmappingid)); if (person_mapping_exists == null) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_Mapping_CheckInPatrolAndHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_Failed; ol_failed.Text = "لم يتم العثور على التوزيع"; _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } var GetPerson = _context.Persons.FirstOrDefault <Persons>(e => e.Personid.Equals(m.Personid)); if (GetPerson == null) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_Mapping_CheckInPatrolAndHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_Failed; ol_failed.Text = "لم يتم العثور على الفرد: " + m.Personid; //todo, change it actual person name _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } if (Convert.ToBoolean(person_mapping_exists.Hasdevices)) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_Mapping_CheckInPatrolAndHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_Failed; ol_failed.Text = "هذا المستخدم يملك حاليا اجهزة"; _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } person_mapping_exists.Patrolid = p.Patrolid; person_mapping_exists.Handheldid = h.Handheldid; person_mapping_exists.Patrolpersonstateid = Core.Handler_AhwalMapping.PatrolPersonState_SunRise; person_mapping_exists.Sunrisetimestamp = DateTime.Now; person_mapping_exists.Sunsettimestamp = null;//we have to reset this time person_mapping_exists.Hasdevices = Convert.ToByte(1); person_mapping_exists.Laststatechangetimestamp = DateTime.Now; _context.SaveChanges(); //log it //we have to add this record in checkIn and CheckOut Table var PatrolCheckInLog = new Patrolcheckinout(); PatrolCheckInLog.Checkinoutstateid = Core.Handler_AhwalMapping.CheckInState; PatrolCheckInLog.Timestamp = DateTime.Now; PatrolCheckInLog.Personid = m.Personid; PatrolCheckInLog.Patrolid = p.Patrolid; _context.Patrolcheckinout.Add(PatrolCheckInLog); var HandHeldCheckInLog = new Handheldscheckinout(); HandHeldCheckInLog.Checkinoutstateid = Core.Handler_AhwalMapping.CheckInState; HandHeldCheckInLog.Timestamp = DateTime.Now; HandHeldCheckInLog.Personid = m.Personid; HandHeldCheckInLog.Handheldid = h.Handheldid; _context.Handheldscheckinout.Add(HandHeldCheckInLog); _context.SaveChanges(); //record this in personstatechangelog var personStateLog = new Patrolpersonstatelog(); personStateLog.Userid = u.Userid; personStateLog.Patrolpersonstateid = Core.Handler_AhwalMapping.PatrolPersonState_SunRise; personStateLog.Timestamp = DateTime.Now; personStateLog.Personid = m.Personid; LogPersonStateChange(personStateLog); Operationlogs ol = new Operationlogs(); ol.Userid = u.Userid; ol.Operationid = Handler_Operations.Opeartion_Mapping_CheckInPatrolAndHandHeld; ol.Statusid = Handler_Operations.Opeartion_Status_Success; ol.Text = "تم تسليم الفرد: " + GetPerson.Milnumber.ToString() + " " + GetPerson.Name + " الدورية رقم: " + p.Platenumber + " والجهاز رقم: " + h.Serial; _oper.Add_New_Operation_Log(ol); return(ol); } catch (Exception ex) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_Mapping_CheckOutPatrolAndHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_UnKnownError; ol_failed.Text = ex.Message; _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } }
public IActionResult PostCheckInAhwalMapping([FromBody] JObject RqHdr) { var selectedPerson = RqHdr["personMno"].ToString(); // var selectedPatrol = RqHdr["plateNumber"].ToString(); var selectedPatrol = Newtonsoft.Json.JsonConvert.DeserializeObject <string>(RqHdr["plateNumber"].ToString(), new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore }); var selectedHandHeld = Newtonsoft.Json.JsonConvert.DeserializeObject <string>(RqHdr["serial"].ToString(), new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore }); string responsemsg = ""; Users user = new Users(); user.Userid = Convert.ToInt32(RqHdr["userid"]); if (selectedPerson == null) { responsemsg = "يرجى اختيار الفرد"; return(Ok(responsemsg)); } var person = _person.GetPersonForUserForRole(user, Convert.ToInt64(selectedPerson), Core.Handler_User.User_Role_Ahwal); if (person == null) { responsemsg = "لم يتم العثور على الفرد"; return(Ok(responsemsg)); } if (selectedPatrol == null) { responsemsg = "يرجى اختيار الدورية"; return(Ok(responsemsg)); } var patrol = _patrol.GetPatrolCarByPlateNumberForUserForRole(user, selectedPatrol.ToString().Trim(), Core.Handler_User.User_Role_Ahwal); if (patrol == null) { responsemsg = "لم يتم العثور على الدورية"; return(Ok(responsemsg)); } if (selectedHandHeld == null) { responsemsg = "يرجى اختيار الجهاز"; return(Ok(responsemsg)); } var handheld = _handheld.GetHandHeldBySerialForUserForRole(user, selectedHandHeld.ToString().Trim(), Core.Handler_User.User_Role_Ahwal); var personMapping = _ahwalmapping.GetMappingByPersonID(user, person); if (personMapping == null) { responsemsg = "لم يتم العثور على الفرد في الكشف"; return(Ok(responsemsg)); } //lets see if this person already has devices, if he does, then its checkout, if not, then its checkin if (Convert.ToBoolean(personMapping.Hasdevices)) //checkout { if (personMapping.Patrolid != patrol.Patrolid) { var getPatrol = new Patrolcars(); getPatrol.Patrolid = (int)personMapping.Patrolid; getPatrol.Ahwalid = personMapping.Ahwalid; var patrolexists = _patrol.GetPatrolCardByID(user, getPatrol); if (patrolexists != null) { responsemsg = "يجب تسليم نفس الدورية المستلمه رقم: " + patrolexists.Platenumber; return(Ok(responsemsg)); } } if (personMapping.Handheldid != handheld.Handheldid) { var getHandHeld = new Handhelds(); getHandHeld.Handheldid = (int)personMapping.Handheldid; getHandHeld.Ahwalid = personMapping.Ahwalid; var handHeldExist = _handheld.GetHandHeldByID(user, getHandHeld); if (handHeldExist != null) { responsemsg = "يجب تسليم نفس الجهاز المستلم رقم: " + handHeldExist.Serial; return(Ok(responsemsg)); } } var result = _ahwalmapping.CheckOutPatrolAndHandHeld(user, personMapping, patrol, handheld); responsemsg = result.Text; return(Ok(responsemsg)); } else {//check in if (_ahwalmapping.PatrolCarWithSomeOneElse(user, person.Personid, patrol.Patrolid)) { responsemsg = "الدورية بحوزة شخص اخر"; return(Ok(responsemsg)); } if (_ahwalmapping.HandHeldWithSomeOneElse(user, person.Personid, handheld.Handheldid)) { responsemsg = "الجهاز بحوزة شخص اخر"; return(Ok(responsemsg)); } if (Convert.ToBoolean(patrol.Defective)) { responsemsg = "هذه الدورية غير صالحه"; return(Ok(responsemsg)); } if (Convert.ToBoolean(handheld.Defective)) { responsemsg = "هذه الجهاز غير صالح"; return(Ok(responsemsg)); } //ok no body else has, the devices are good and not defected var result = _ahwalmapping.CheckInPatrolAndHandHeld(user, personMapping, patrol, handheld); responsemsg = result.Text; return(Ok(responsemsg)); } }