public void UpdateInquiryImages(InquiryDetails quiryDetails) { try { DALComponent objDAL = new DALComponent(); objDAL.SetParameters("@inquiryId", SqlDbType.Int, 4, quiryDetails.InquiryID); objDAL.SetParameters("@imagepath", SqlDbType.VarChar, 500, quiryDetails.ImagePath); objDAL.SetParameters("@videopath", SqlDbType.VarChar, 200, quiryDetails.VideoPath); objDAL.SqlCommandText = "[UpdateInquiryImages]"; int x = objDAL.UpdateRecord(); } catch (SqlException sqlEx) { throw new ApplicationException("Data error=" + sqlEx.Message.ToString()); } catch (Exception ex) { throw new ApplicationException("Error=" + ex.Message.ToString()); } }
public void UpdateVendorPassword(VendorDetails venDetails) { try { DALComponent objDAL = new DALComponent(); objDAL.SetParameters("@vendorId", SqlDbType.Int, 4, venDetails.VendorID); objDAL.SetParameters("@password", SqlDbType.VarChar, 100, venDetails.LoginPassword); objDAL.SqlCommandText = "[UpdateVendorPassword]"; int x = objDAL.UpdateRecord(); } catch (SqlException sqlEx) { throw new ApplicationException("Data error=" + sqlEx.Message.ToString()); } catch (Exception ex) { throw new ApplicationException("Error=" + ex.Message.ToString()); } }
public void UpdateCustomerImage(CustomerDetails cusDetails) { try { DALComponent objDAL = new DALComponent(); objDAL.SetParameters("@customerId", SqlDbType.Int, 4, cusDetails.CustomerID); objDAL.SetParameters("@imagepath", SqlDbType.VarChar, 100, cusDetails.ImagePath); objDAL.SqlCommandText = "[UpdateCustomerImage]"; int x = objDAL.UpdateRecord(); } catch (SqlException sqlEx) { throw new ApplicationException("Data error=" + sqlEx.Message.ToString()); } catch (Exception ex) { throw new ApplicationException("Error=" + ex.Message.ToString()); } }