public async Task <string> SaveDirectClientEnq(utblClientEnquirie model) { if (ModelState.IsValid) { return(await objDAL.SaveDirectClientEnqAsync(model)); } string messages = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)); return("Operation Error: " + messages); }
public async Task <string> SaveDirectClientEnqAsync(utblClientEnquirie model) { try { var parClientName = new SqlParameter("@ClientName", model.ClientName); var parClientEmail = new SqlParameter("@ClientEmail", model.ClientEmail); var parClientPhoneNo = new SqlParameter("@ClientPhoneNo", model.ClientPhoneNo); var parRefPackageID = new SqlParameter("@RefPackageID", model.RefPackageID); var parNoOfDays = new SqlParameter("@NoOfDays", model.NoOfDays); var parRemarks = new SqlParameter("@Remarks", model.Remarks ?? ""); var parDateOfArrival = new SqlParameter("@DateOfArrival", model.DateOfArrival); var parNoOfAdult = new SqlParameter("@NoOfAdult", model.NoOfAdult); var parNoOfChildren = new SqlParameter("@NoOfChildren", model.NoOfChildren); var parHotelTypeID = new SqlParameter("@HotelTypeID", DBNull.Value); if (model.HotelTypeID != null || model.HotelTypeID != 0) { parHotelTypeID = new SqlParameter("@HotelTypeID", model.HotelTypeID); } var parCabTypeID = new SqlParameter("@CabTypeID", DBNull.Value); if (model.CabTypeID != null || model.CabTypeID != 0) { parCabTypeID = new SqlParameter("@CabTypeID", model.CabTypeID); } var parIsDirectBooking = new SqlParameter("@IsDirectBooking", model.IsDirectBooking); var parStatus = new SqlParameter("@Status", model.Status); var parTransDate = new SqlParameter("@TransDate", model.TransDate); if (model.EnquiryCode == "" || model.EnquiryCode == null) { return(await objDB.Database.SqlQuery <string>("udspDirectClientEnquiryInsert @ClientName, @ClientEmail,@ClientPhoneNo,@RefPackageID,@NoOfDays,@Remarks,@DateOfArrival,@NoOfAdult,@NoOfChildren,@HotelTypeID,@CabTypeID,@IsDirectBooking,@Status,@TransDate", parClientName, parClientEmail, parClientPhoneNo, parRefPackageID, parNoOfDays, parRemarks, parDateOfArrival, parNoOfAdult, parNoOfChildren, parHotelTypeID, parCabTypeID, parIsDirectBooking, parStatus, parTransDate).FirstOrDefaultAsync()); } else { var parEnquiryCode = new SqlParameter("@EnquiryCode", model.EnquiryCode); return(await objDB.Database.SqlQuery <string>("udspCustomClientEnquiryUpdate @EnquiryCode, @ClientName, @ClientEmail,@ClientPhoneNo,@NoOfDays,@DateOfArrival,@NoOfAdult,@NoOfChildren,@HotelTypeID,@CabTypeID,@Status,@TransDate", parEnquiryCode, parClientName, parClientEmail, parClientPhoneNo, parNoOfDays, parDateOfArrival, parNoOfAdult, parNoOfChildren, parHotelTypeID, parCabTypeID, parStatus, parTransDate).FirstOrDefaultAsync()); } } catch (Exception ex) { return("Error: " + ex.Message); } }
public async Task <string> UpdateClientEnquiryStatusAsync(ClientEnquiryView model) { try { utblClientEnquirie cmodel = await objDB.utblClientEnquiries.Where(x => x.EnquiryCode == model.EnquiryCode).FirstOrDefaultAsync(); cmodel.Status = "Submitted"; await objDB.SaveChangesAsync(); return("Status Updated"); } catch (SqlException ex) { return("Error Message: " + ex.Message); } catch (Exception ex) { return("Error: " + ex.Message); } }