public DataTable AssesorJobTransfer(string MOI, string username, string assesorname) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); inputParameter.Add("V_USERID", username); inputParameter.Add("V_NEW_ASSE_CODE", assesorname); inputParameter.Add("V_JOB_NO", MOI); DataTable a = DatabaseUtility.PopulateDataWithReturn(GenericStoredProcedure.AssesorJobTransfer, inputParameter); return(a); }
public DataTable InsertImageUploadError(Int32 ID, Int32 IMGID, string imgpath) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); inputParameter.Add("V_ID", ID); inputParameter.Add("V_IMG_ID", IMGID); inputParameter.Add("V_PATH", imgpath); DataTable a = DatabaseUtility.PopulateDataWithReturn(GenericStoredProcedure.InsertImageUploadError, inputParameter); return(a); }
public DataTable InsertAssesorDetails(string assesorname, string contact, string location, string address, string position, string emieno) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); inputParameter.Add("V_ASSESOR_NAME", assesorname); inputParameter.Add("V_CONTACT", contact); inputParameter.Add("V_LOCATION", location); inputParameter.Add("V_ADDRESS", address); inputParameter.Add("V_POSITION", position); inputParameter.Add("V_EMIE_NO", emieno); DataTable a = DatabaseUtility.PopulateDataWithReturn(GenericStoredProcedure.InsertAssesorDetails, inputParameter); return(a); }
public DataTable InsertAccidentData(string MOI, string inspection, string imgtype, double lattitude, double longitute, double amount, string paytype) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); inputParameter.Add("V_MOI_NO", MOI); inputParameter.Add("V_INSPECTION", inspection); inputParameter.Add("V_IMG_TYPE", imgtype); inputParameter.Add("V_LATTITUDE", Convert.ToDouble(lattitude)); inputParameter.Add("V_LONGITUDE", Convert.ToDouble(longitute)); inputParameter.Add("V_AMOUNT", Convert.ToDouble(amount)); inputParameter.Add("V_PAYTYPE", paytype); DataTable a = DatabaseUtility.PopulateDataWithReturn(GenericStoredProcedure.InsertAccidentDetails, inputParameter); return(a); }