//all functions here require Ahwal Permssion public Operationlogs Add_HandHeldr(Users u, Handhelds h) //this transaction requires User_Role_Maintenance Permisson on this AhwalID { try { //first we have to check if this Users is authorized to perform this transaction //if (!_user.isAuthorized(u.Userid, h.Ahwalid, Handler_User.User_Role_Maintenance)) //{ // Operationlogs ol_failed = new Operationlogs(); // ol_failed.Userid = u.Userid; // ol_failed.Operationid = Handler_Operations.Opeartion_AddHandHeld; // ol_failed.Statusid = Handler_Operations.Opeartion_Status_UnAuthorized; // ol_failed.Text = "المستخدم لايملك صلاحية هذه العمليه"; // _oper.Add_New_Operation_Log(ol_failed); // return ol_failed; //} //next we need to search if there is a Handhelds with same serial Handhelds HandHeld_exists = _context.Handhelds.FirstOrDefault(e => e.Serial.Equals(h.Serial)); if (HandHeld_exists != null) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_AddHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_Failed; ol_failed.Text = "يوجد لاسلكي بنفس رقم : " + h.Serial; _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } h.Barcode = "HAN" + h.Serial; // var handhelds = _context.Set<Handhelds>(); // handhelds.Add(h); _context.Handhelds.Add(h); _context.SaveChanges(); } catch (Exception ex) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_AddHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_UnKnownError; ol_failed.Text = ex.Message; _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } Operationlogs ol = new Operationlogs(); ol.Userid = u.Userid; ol.Operationid = Handler_Operations.Opeartion_AddHandHeld; ol.Statusid = Handler_Operations.Opeartion_Status_Success; ol.Text = "تم اضافة لاسلكي: " + h.Serial; _oper.Add_New_Operation_Log(ol); return(ol); }
public ActionResult PostHandhelds([FromBody] JObject rqhdr) { var ahwalid = Convert.ToInt64(Newtonsoft.Json.JsonConvert.DeserializeObject <string>(rqhdr["ahwalid"].ToString(), new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore })); //var barcode = Newtonsoft.Json.JsonConvert.DeserializeObject<string>(rqhdr["barcode"].ToString(), new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore }); var defective = Convert.ToByte(Newtonsoft.Json.JsonConvert.DeserializeObject <string>(rqhdr["defective"].ToString(), new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore })); var serial = Newtonsoft.Json.JsonConvert.DeserializeObject <string>(rqhdr["serial"].ToString(), new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore }); var userid = Newtonsoft.Json.JsonConvert.DeserializeObject <string>(rqhdr["userid"].ToString(), new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore }); var transmode = rqhdr["transmode"].ToString(); var handheldid = Convert.ToInt64(Newtonsoft.Json.JsonConvert.DeserializeObject <string>(rqhdr["handheldid"].ToString(), new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore })); Users user = new Users(); user.Userid = Convert.ToInt32(rqhdr["userid"]); Handhelds h = new Handhelds(); h.Ahwalid = ahwalid; h.Serial = serial; h.Defective = defective; Operationlogs result; if (transmode == "UPDATE") { h.Handheldid = handheldid; result = _handheld.Update_HandHeld(user, h); } else { result = _handheld.Add_HandHeldr(user, h); } if (result.Statusid == Core.Handler_Operations.Opeartion_Status_Success) { return(Ok(result.Text)); } else { return(Ok(result.Text)); } }
public Handhelds GetHandHeldByID(Users u, Handhelds h) { //first we have to check if this Users is authorized to perform this transaction if (!_user.isAuthorized(u.Userid, h.Ahwalid, Handler_User.User_Role_Ahwal)) { return(null); //we dont need to log this since its just read operation } var result = _context.Handhelds.FirstOrDefault <Handhelds>(e => e.Handheldid == h.Handheldid); if (result != null) { return(result); } return(null); }
public int PostDeletehandheld([FromBody] Handhelds frm) { int ret = 0; NpgsqlConnection cont = new NpgsqlConnection(); cont.ConnectionString = constr; cont.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = cont; cmd.CommandText = "delete from Handhelds where handheldid=" + frm.Handheldid; ret = cmd.ExecuteNonQuery(); cont.Close(); cont.Dispose(); return(ret); }
public int PostUpdateHandhelds([FromBody] Handhelds frm) { int ret = 0; NpgsqlConnection cont = new NpgsqlConnection(); cont.ConnectionString = constr; cont.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = cont; cmd.CommandText = "update Handhelds set AhwalID = " + frm.Ahwalid + ",serial = '" + frm.Serial + "',defective = " + frm.Defective + ",barcode = '" + frm.Barcode + "' where handheldid=" + frm.Handheldid; ret = cmd.ExecuteNonQuery(); cont.Close(); cont.Dispose(); return(ret); }
public int PostAddHandhelds([FromBody] Handhelds frm) { int ret = 0; NpgsqlConnection cont = new NpgsqlConnection(); cont.ConnectionString = constr; cont.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = cont; cmd.CommandText = "insert into Handhelds(AhwalID,serial,defective,barcode) values (" + frm.Ahwalid + ",'" + frm.Serial + "'," + frm.Defective + ",'" + frm.Barcode + "')"; ret = cmd.ExecuteNonQuery(); cont.Close(); cont.Dispose(); return(ret); }
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 Operationlogs Update_HandHeld(Users u, Handhelds h) //this transaction requires User_Role_Maintenance Permisson on this AhwalID { try { //first we have to check if this Users is authorized to perform this transaction //if (!_user.isAuthorized(u.Userid, h.Ahwalid, Handler_User.User_Role_Maintenance)) //{ // Operationlogs ol_failed = new Operationlogs(); // ol_failed.Userid = u.Userid; // ol_failed.Operationid = Handler_Operations.Opeartion_UpdateHandHeld; // ol_failed.Statusid = Handler_Operations.Opeartion_Status_UnAuthorized; // ol_failed.Text = "المستخدم لايملك صلاحية هذه العمليه"; // _oper.Add_New_Operation_Log(ol_failed); // return ol_failed; //} //next we need to search if there is a Handhelds car with same serial Handhelds HandHeld_exists = _context.Handhelds.FirstOrDefault(e => e.Handheldid.Equals(h.Handheldid)); if (HandHeld_exists == null) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_UpdateHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_Failed; ol_failed.Text = "لم يتم العثور على لاسلكي بالرقم: " + h.Serial; _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } //we have to make sure as well thats the new serial is not there before if (HandHeld_exists.Serial != h.Serial)//in case only the Users did choose new serial { Handhelds same_HandHeld_serial = _context.Handhelds.FirstOrDefault(e => e.Serial.Equals(h.Serial)); if (same_HandHeld_serial != null) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_UpdateHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_Failed; ol_failed.Text = "يوجد لاسلكي بنفس رقم : " + h.Serial; _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } } HandHeld_exists.Serial = h.Serial; HandHeld_exists.Barcode = "HAN" + h.Serial; //just to make sure no one miss this up even me HandHeld_exists.Defective = h.Defective; HandHeld_exists.Ahwalid = h.Ahwalid; //we are allowing changing of AhwalID for Patrol Cars _context.SaveChanges(); } catch (Exception ex) { Operationlogs ol_failed = new Operationlogs(); ol_failed.Userid = u.Userid; ol_failed.Operationid = Handler_Operations.Opeartion_UpdateHandHeld; ol_failed.Statusid = Handler_Operations.Opeartion_Status_UnKnownError; ol_failed.Text = ex.Message; _oper.Add_New_Operation_Log(ol_failed); return(ol_failed); } Operationlogs ol = new Operationlogs(); ol.Userid = u.Userid; ol.Operationid = Handler_Operations.Opeartion_UpdateHandHeld; ol.Statusid = Handler_Operations.Opeartion_Status_Success; ol.Text = "تم تعديل بيانات اللاسلكي: " + h.Handheldid; _oper.Add_New_Operation_Log(ol); return(ol); }
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)); } }