public List <AuditCarDetail> AuditCarCheckList([FromBody] AuditCarDetail auditcardetails) { return(AuditUtility.GetAuditCarCheckList(auditcardetails)); }
public static List <AuditCarDetail> GetAuditCarCheckList(AuditCarDetail auditcardetails) { try { if ((auditcardetails != null)) // && (U.Macaddress == "48:13:7e:11:d7:1f")) { auditcardetails.ValidFormat = CarUtility.CheckFormatVin(auditcardetails.Vin); if (auditcardetails.ValidFormat) { auditcardetails.VinWithoutChar = CarUtility.GetVinWithoutChar(auditcardetails.Vin); string commandtext = string.Format(@"select d.srl, a.vin, a.areacode, d.strenghtdesc, d.modulecode, d.defectcode, d.modulename, d.defectdesc, d.title, a.areacode || a.areadesc as AreaDesc,a.Auditor2, a.Auditor2 as CreatedByDesc, a.CreatedBy, a.AUDITDATE_fa ||' '|| a.CREATEDTIME as AuditDateFa from sva_v_auditcardetail d left join sva_v_auditcar a on a.srl = d.svaauditcar_srl where a.vin = '{0}' ", auditcardetails.Vin); DataSet ds = DBHelper.ExecuteMyQueryIns(commandtext); // -- //string jsonString = string.Empty; //jsonString = JsonConvert.SerializeObject(ds.Tables[0]); //return jsonString; // -- List <AuditCarDetail> FoundDefects = new List <AuditCarDetail>(); FoundDefects = DBHelper.GetDBObjectByObj2(new AuditCarDetail(), null, commandtext, "inspector").Cast <AuditCarDetail>().ToList(); //--- if (FoundDefects.Count > 0) { FoundDefects[0].ValidFormat = auditcardetails.ValidFormat; FoundDefects[0].VinWithoutChar = auditcardetails.VinWithoutChar; FoundDefects[0].Msg = auditcardetails.Msg = ""; return(FoundDefects); } else { List <AuditCarDetail> q = new List <AuditCarDetail>(); auditcardetails.Msg = "اطلاعاتی یافت نشد"; q.Add(auditcardetails); return(null); } } else { List <AuditCarDetail> q = new List <AuditCarDetail>(); auditcardetails.Msg = "شاسی غیر مجاز است"; q.Add(auditcardetails); return(q); } } else { DBHelper.LogtxtToFile("z null"); return(null); } } catch (Exception e) { //string err = e.ToString() + e.InnerException.Message + e.Message.ToString(); DBHelper.LogFile(e); List <AuditCarDetail> q = new List <AuditCarDetail>(); auditcardetails.Msg = e.Message; q.Add(auditcardetails); return(q); } }