public bool Update(QuoteDetails _quote) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", _quote.ID), new SqlParameter("@Insured_Name", _quote.Insured_Name), new SqlParameter("@Mailing_Address1", _quote.Mailing_Address1), new SqlParameter("@Mailing_Address2", _quote.Mailing_Address2), new SqlParameter("@ZipCode", _quote.ZipCode), new SqlParameter("@City", _quote.City), new SqlParameter("@Insured_State_ID", _quote.Insured_State_ID), new SqlParameter("@Home_State_ID", _quote.Home_State_ID), new SqlParameter("@Is_new_business", _quote.Is_new_business), new SqlParameter("@Years_Without_Loss", _quote.Years_Without_Loss), new SqlParameter("@Effective_Date", _quote.Effective_Date), new SqlParameter("@Expiration_Date", _quote.Expiration_Date), new SqlParameter("@LOB_GeneralLiability", _quote.LOB_GeneralLiability), new SqlParameter("@LOB_VacantBuildingGL", _quote.LOB_VacantBuildingGL), new SqlParameter("@LOB_Owners", _quote.LOB_Owners), new SqlParameter("@LOB_SpecialEvent", _quote.LOB_SpecialEvent), new SqlParameter("@LOB_Property", _quote.LOB_Property), new SqlParameter("@LOB_VacantBuildingProperty", _quote.LOB_VacantBuildingProperty), new SqlParameter("@LOB_BuilderRisk", _quote.LOB_BuilderRisk), new SqlParameter("@LOB_Crime", _quote.LOB_Crime), new SqlParameter("@LOB_InlandMarine", _quote.LOB_InlandMarine), new SqlParameter("@LOB_ContractorsEquipment", _quote.LOB_ContractorsEquipment), new SqlParameter("@LOB_MotorTruck", _quote.LOB_MotorTruck), new SqlParameter("@LOB_Garage", _quote.LOB_Garage), new SqlParameter("@UserID", _quote.UserID), new SqlParameter("@QuoteNo", _quote.QuoteNo), new SqlParameter("@QuoteStatus", _quote.QuoteStatus), }; return(SqlDBHelper.ExecuteNonQuery("proc_QuoteDetails_Update", CommandType.StoredProcedure, parameters)); }
public bool Update(Property _property) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", _property.ID), new SqlParameter("@QuoteID", _property.QuoteID), new SqlParameter("@Address1", _property.Address1), new SqlParameter("@Address2", _property.Address2), new SqlParameter("@Zip", _property.Zip), new SqlParameter("@City", _property.City), new SqlParameter("@StateID", _property.StateID), new SqlParameter("@ProtectionClass", _property.ProtectionClass), new SqlParameter("@ClassID", _property.ClassID), new SqlParameter("@StructureDescription", _property.StructureDescription), new SqlParameter("@ConstructionType", _property.ConstructionType), new SqlParameter("@ConstType_ApplySpriniderSafeguardP1", _property.ConstType_ApplySpriniderSafeguardP1), new SqlParameter("@ConstType_ExcludeWindHall", _property.ConstType_ExcludeWindHall), new SqlParameter("@HigherWindHall", _property.HigherWindHall), new SqlParameter("@YearBuilt", _property.YearBuilt), new SqlParameter("@LastCompleteUpdateYear", _property.LastCompleteUpdateYear), new SqlParameter("@Plumbing", _property.Plumbing), new SqlParameter("@Rooting", _property.Rooting), new SqlParameter("@Wiring", _property.Wiring), new SqlParameter("@Coverage_Building", _property.Coverage_Building), new SqlParameter("@Coverage_BusinessPersonalProperty", _property.Coverage_BusinessPersonalProperty), new SqlParameter("@Coverage_BusinessIncome", _property.Coverage_BusinessIncome), new SqlParameter("@Coverage_PersonalPropertyofOthers", _property.Coverage_PersonalPropertyofOthers), new SqlParameter("@Coverage_Signs", _property.Coverage_Signs), new SqlParameter("@Coverage_PropertyInOpen", _property.Coverage_PropertyInOpen), }; return(SqlDBHelper.ExecuteNonQuery("proc_Property_Update", CommandType.StoredProcedure, parameters)); }
public bool Update(RuleDesc _rule) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", _rule.ID), new SqlParameter("@RuleMastID", _rule.RuleMastID), new SqlParameter("@RuleName", _rule.RuleName), new SqlParameter("@SplitAs", _rule.SplitAs), new SqlParameter("@Dictionary", _rule.Dictionary), new SqlParameter("@OriginalDocumentName", _rule.OriginalDocumentName), new SqlParameter("@ConvertedDocumentName", _rule.ConvertedDocumentName), new SqlParameter("@EntryDate", _rule.EntryDate), new SqlParameter("@ModifiedDate", _rule.ModifiedDate), new SqlParameter("@IsActive", _rule.IsActive), new SqlParameter("@NeighbourhoodCount", _rule.NeighbourhoodCount), new SqlParameter("@Expression1", _rule.Expression1), new SqlParameter("@Expression2", _rule.Expression2), new SqlParameter("@ContextWord", _rule.ContextWord), new SqlParameter("@Operator", _rule.Operator), new SqlParameter("@FieldName", _rule.FieldName), new SqlParameter("@FieldValue", _rule.FieldValue), new SqlParameter("@UploadedFile", _rule.UploadedFile), new SqlParameter("@IsIgnoreKeyword", _rule.IsIgnoreKeyword), new SqlParameter("@FieldPosition", _rule.FieldPosition), new SqlParameter("@IsCheckSynonyms", _rule.IsCheckSynonyms), new SqlParameter("@Synonyms", _rule.Synonyms), new SqlParameter("@AllSynonyms", _rule.AllSynonyms), new SqlParameter("@ExpressionContext", _rule.ExpressionContext), }; return(SqlDBHelper.ExecuteNonQuery("proc_RuleDesc_Update", CommandType.StoredProcedure, parameters)); }
public bool UpdateQuizAns(QuizAns quiz) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@courseID", quiz.courseID), new SqlParameter("@studentID", quiz.studentID), new SqlParameter("@questionID", quiz.questionID), new SqlParameter("@Ans", quiz.Ans), }; if (SqlDBHelper.ExecuteNonQuery("UpdateQuizAns", CommandType.StoredProcedure, parameters) == true) { return(true); } else { SqlParameter[] parameters1 = new SqlParameter[] { new SqlParameter("@courseID", quiz.courseID), new SqlParameter("@studentID", quiz.studentID), new SqlParameter("@questionID", quiz.questionID), new SqlParameter("@Ans", quiz.Ans), }; return(SqlDBHelper.ExecuteNonQuery("AddNewQuizAns", CommandType.StoredProcedure, parameters1)); } } catch { throw; } }
internal bool updateCustomer(Customer customer) { try { parameters = new SqlParameter[] { new SqlParameter("@pCustomerId", customer.CustomerId), new SqlParameter("@pName", customer.Name), new SqlParameter("@pEmailId", customer.EmailId), new SqlParameter("@pPhoneNo", customer.PhoneNo), new SqlParameter("@pGSTN", customer.GSTN), new SqlParameter("@pAddressLine1", customer.AddressLine1), new SqlParameter("@pAddressLine2", customer.AddressLine2), new SqlParameter("@pCity", customer.City), new SqlParameter("@pState", customer.State), new SqlParameter("@pZipCode", customer.ZipCode), new SqlParameter("@pModifiedBy", customer.ModifiedBy) }; return(SqlDBHelper.ExecuteNonQuery("app_UpdateCustomers", CommandType.StoredProcedure, parameters)); } catch { return(false); } }
public bool AddNewCourse(Course course) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@courseCode", course.courseCode), new SqlParameter("@courseName", course.courseName), new SqlParameter("@semester", course.semester), new SqlParameter("@year", course.year), new SqlParameter("@enrollKey", course.enrollKey), }; if (SqlDBHelper.ExecuteNonQuery("AddNewCourse", CommandType.StoredProcedure, parameters) == true) { SqlParameter[] parameters1 = new SqlParameter[] { new SqlParameter("@courseID", course.courseID), new SqlParameter("@teacherID", course.teacherID), }; return(SqlDBHelper.ExecuteNonQuery("AddNewTeacherCourse", CommandType.StoredProcedure, parameters1)); } else { return(false); } } catch { throw; } }
public bool Delete(int id) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", id) }; return(SqlDBHelper.ExecuteNonQuery("proc_UserMaster_Delete", CommandType.StoredProcedure, parameters)); }
public bool DeleteEmployee(int empID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@empId", empID) }; return(SqlDBHelper.ExecuteNonQuery("DeleteEmployee", CommandType.StoredProcedure, parameters)); }
public bool UpdateActiveInActive(UserMaster _user) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", _user.ID), new SqlParameter("@IsActive", _user.IsActive), }; return(SqlDBHelper.ExecuteNonQuery("proc_UserMaster_UpdateActiveInactive", CommandType.StoredProcedure, parameters)); }
public bool Update(Configuration _config) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", _config.ID), new SqlParameter("@ConfigurationValue", _config.ConfigurationValue), new SqlParameter("@ModifiedDate", _config.ModifiedDate), }; return(SqlDBHelper.ExecuteNonQuery("proc_Configuration_Update", CommandType.StoredProcedure, parameters)); }
public bool AddNew(APICallHistory _history) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@RunTime", _history.RunTime), new SqlParameter("@Comment", _history.Comment), new SqlParameter("@Status", _history.Status), new SqlParameter("@RunID", _history.RunID), }; return(SqlDBHelper.ExecuteNonQuery("proc_APICallHistory_AddNew", CommandType.StoredProcedure, parameters)); }
internal int addOrder(Order order, List <OrderItems> listItems) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@pOrderDate", order.OrderDate), new SqlParameter("@pBillToContact", order.BillToContact), new SqlParameter("@pBillToGSTN", order.BillToGSTN), new SqlParameter("@pBillToEmail", order.BillToEmail), new SqlParameter("@pBillToPhone", order.BillToPhone), new SqlParameter("@pBillToAddress1", order.BillToAddress1), new SqlParameter("@pBillToAddress2", order.BillToAddress2), new SqlParameter("@pBillToCity", order.BillToCity), new SqlParameter("@pBillToState", order.BillToState), new SqlParameter("@pBillToZip", order.BillToZip), new SqlParameter("@pDiscount", order.Discount), new SqlParameter("@pCGSTRate", order.CGSTRate), new SqlParameter("@pSGSTRate", order.SGSTRate), new SqlParameter("@pIGSTRate", order.IGSTRate), new SqlParameter("@pTaxablePrice", order.TaxablePrice), new SqlParameter("@pTotalProductPrice", order.TotalProductPrice), new SqlParameter("@pGrandtotal", order.Grandtotal), new SqlParameter("@GrandtotalInWords", order.GrandtotalInWords), new SqlParameter("@pCreatedBy", 1) }; order.OrderId = Convert.ToInt32(SqlDBHelper.ExecuteNonQueryReturnData("app_AddOrder", CommandType.StoredProcedure, parameters, "pOrderId")); if (order.OrderId != null) { if (listItems.Count() > 0) { foreach (OrderItems item in listItems) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@pOrderId", order.OrderId), new SqlParameter("@pMaterialId", item.MaterialId), new SqlParameter("@pMaterialName", item.MaterialName), new SqlParameter("@pHSNCode", item.HSNCode), new SqlParameter("@pQuantity", item.Quantity), new SqlParameter("@pUnitPrice", item.UnitPrice), new SqlParameter("@pTotalPrice", item.TotalPrice) }; SqlDBHelper.ExecuteNonQuery("app_AddOrderItems", CommandType.StoredProcedure, param); } } } return(order.OrderId); } catch (Exception ex) { return(0); } }
public bool AddNew(RuleMast _rule) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@RuleName", _rule.RuleName), new SqlParameter("@CreateDate", _rule.CreateDate), new SqlParameter("@ModifiedDate", _rule.ModifiedDate), new SqlParameter("@IsActive", _rule.IsActive), }; return(SqlDBHelper.ExecuteNonQuery("proc_RuleMast_AddNew", CommandType.StoredProcedure, parameters)); }
internal bool uploadCustomersForExcel() { try { parameters = new SqlParameter[] { }; return(SqlDBHelper.ExecuteNonQuery("UploadCustomerExcelData", CommandType.StoredProcedure, parameters)); } catch { return(false); } }
public bool AddNew(APIRuleApplicationSummary _ruleSummary) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@RunID", _ruleSummary.RunID), new SqlParameter("@FileName", _ruleSummary.FileName), new SqlParameter("@RuleDescID", _ruleSummary.RuleDescID), new SqlParameter("@FieldValue", _ruleSummary.FieldValue), new SqlParameter("@EntryDate", _ruleSummary.EntryDate), new SqlParameter("@IsSuccess", _ruleSummary.IsSuccess), }; return(SqlDBHelper.ExecuteNonQuery("proc_APIRuleApplicationSummary_AddNew", CommandType.StoredProcedure, parameters)); }
internal bool deleteMaterial(int materialId) { try { parameters = new SqlParameter[] { new SqlParameter("@pMaterialId", materialId) }; return(SqlDBHelper.ExecuteNonQuery("app_DeleteMaterial", CommandType.StoredProcedure, parameters)); } catch { return(false); } }
public bool UpdateorInsert(RuleEngineDetails _rule) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@RuleMastID", _rule.RuleMastID), new SqlParameter("@RuleDescID", _rule.RuleDescID), new SqlParameter("@FolderPath", _rule.FolderPath), new SqlParameter("@UserID", _rule.UserID), new SqlParameter("@CreateDate", _rule.CreateDate), new SqlParameter("@ModifiedDate", _rule.ModifiedDate), new SqlParameter("@IsActive", _rule.IsActive), }; return(SqlDBHelper.ExecuteNonQuery("proc_RuleEngineDetails_InsertAndUpdate", CommandType.StoredProcedure, parameters)); }
internal bool deleteCustomer(int CustomerId) { try { parameters = new SqlParameter[] { new SqlParameter("@pCustomerId", CustomerId) }; return(SqlDBHelper.ExecuteNonQuery("app_DeleteCustomers", CommandType.StoredProcedure, parameters)); } catch { return(false); } }
public bool AddNewStudentCourse(int cid, int sid) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@courseID", cid), new SqlParameter("@studentID", sid), }; return(SqlDBHelper.ExecuteNonQuery("AddNewStudentCourse", CommandType.StoredProcedure, parameters)); } catch { throw; } }
public bool EndQuizz(int cid) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@courseID", cid), new SqlParameter("@setq", "0"), }; return(SqlDBHelper.ExecuteNonQuery("StartQuiz", CommandType.StoredProcedure, parameters)); } catch { throw; } }
public bool AddNew(LimitDetails _limit) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Quote_ID", _limit.Quote_ID), new SqlParameter("@EachOccurence", _limit.EachOccurence), new SqlParameter("@GeneralAggregate", _limit.GeneralAggregate), new SqlParameter("@PremisesDamage", _limit.PremisesDamage), new SqlParameter("@MedicalExpense", _limit.MedicalExpense), new SqlParameter("@ProductCompleted", _limit.ProductCompleted), new SqlParameter("@DeductablePerClaim", _limit.DeductablePerClaim), new SqlParameter("@PersonalInjury", _limit.PersonalInjury), }; return(SqlDBHelper.ExecuteNonQuery("proc_LimitDetails_AddNew", CommandType.StoredProcedure, parameters)); }
public bool AddNewEmployee(Employee employee) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@LastName", employee.LastName), new SqlParameter("@FirstName", employee.FirstName), new SqlParameter("@Title", employee.Title), new SqlParameter("@Address", employee.Address), new SqlParameter("@City", employee.City), new SqlParameter("@Region", employee.Region), new SqlParameter("@PostalCode", employee.PostalCode), new SqlParameter("@Country", employee.Country), new SqlParameter("@Extension", employee.Extension) }; return(SqlDBHelper.ExecuteNonQuery("AddNewEmployee", CommandType.StoredProcedure, parameters)); }
public bool AddNewNotice(Notice notice) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@notice", notice.notice), new SqlParameter("@date", notice.date), new SqlParameter("@courseID", notice.courseID), }; return(SqlDBHelper.ExecuteNonQuery("AddNewNotice", CommandType.StoredProcedure, parameters)); } catch { throw; } }
public bool AddNewQuestion(Question ques) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@question", ques.QuestionFor), new SqlParameter("@choiceA", ques.ChoiceA), new SqlParameter("@choiceB", ques.ChoiceB), new SqlParameter("@choiceC", ques.ChoiceC), new SqlParameter("@choiceD", ques.ChoiceD), new SqlParameter("@teacherAns", ques.TeacherAns), new SqlParameter("@studentAns", ques.StudentAns), new SqlParameter("@questionFor", ques.QuestionType), new SqlParameter("@set", ques.set), new SqlParameter("@courseID", ques.courseID), }; return(SqlDBHelper.ExecuteNonQuery("AddNewQuestion", CommandType.StoredProcedure, parameters)); }
public bool AddNew(ClassDetails _class) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Zip", _class.Zip), new SqlParameter("@Quote_ID", _class.Quote_ID), new SqlParameter("@StateID", _class.StateID), new SqlParameter("@Territory", _class.Territory), new SqlParameter("@ClassID", _class.ClassID), new SqlParameter("@Exposure", _class.Exposure), new SqlParameter("@Cov_Product", _class.Cov_Product), new SqlParameter("@Cov_Premises", _class.Cov_Premises), new SqlParameter("@Territory_ID", _class.Territory_ID), }; return(SqlDBHelper.ExecuteNonQuery("proc_ClassDetails_AddNew", CommandType.StoredProcedure, parameters)); }
public bool AddNewTeacher(Teacher course) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@fullName", course.teacherName), new SqlParameter("@email", course.email), new SqlParameter("@password", course.password), }; return(SqlDBHelper.ExecuteNonQuery("AddNewTeacher", CommandType.StoredProcedure, parameters)); } catch { throw; } }
public bool AddNewStudent(Student course) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@fullName", course.studentName), new SqlParameter("@IdNumber", course.idNumber), new SqlParameter("@email", course.email), new SqlParameter("@password", course.password), }; return(SqlDBHelper.ExecuteNonQuery("AddNewStudent", CommandType.StoredProcedure, parameters)); } catch { throw; } }
public bool AddNewDiscussion(Discussion course) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Name", course.name), new SqlParameter("@courseID", course.courseID), new SqlParameter("@post", course.post), new SqlParameter("@email", course.email), }; return(SqlDBHelper.ExecuteNonQuery("AddNewDiscussion", CommandType.StoredProcedure, parameters)); } catch { throw; } }
internal bool updateMaterial(Material material) { try { parameters = new SqlParameter[] { new SqlParameter("@pMaterialId", material.MaterialId), new SqlParameter("@pMaterialCode", material.MaterialCode), new SqlParameter("@pMaterialName", material.MaterialName), new SqlParameter("@pMaterialDescription", material.MaterialDescription), new SqlParameter("@pHSNCode", material.HSNCode), new SqlParameter("@pOneKGSize", material.Prices.OneKGSize), new SqlParameter("@pOneKGPrice", material.Prices.OneKGPrice), new SqlParameter("@pHalfKGSize", material.Prices.HalfKGSize), new SqlParameter("@pHalfKGPrice", material.Prices.HalfKGPrice), new SqlParameter("@pSize1", material.Prices.Size1), new SqlParameter("@pPrice1", material.Prices.Price1), new SqlParameter("@pSize2", material.Prices.Size2), new SqlParameter("@pPrice2", material.Prices.Price2), new SqlParameter("@pSize3", material.Prices.Size3), new SqlParameter("@pPrice3", material.Prices.Price3), new SqlParameter("@pSize4", material.Prices.Size4), new SqlParameter("@pPrice4", material.Prices.Price4), new SqlParameter("@pSize5", material.Prices.Size5), new SqlParameter("@pPrice5", material.Prices.Price5), new SqlParameter("@pSize6", material.Prices.Size6), new SqlParameter("@pPrice6", material.Prices.Price6), new SqlParameter("@pSize7", material.Prices.Size7), new SqlParameter("@pPrice7", material.Prices.Price7), new SqlParameter("@pSize8", material.Prices.Size8), new SqlParameter("@pPrice8", material.Prices.Price8), new SqlParameter("@pSize9", material.Prices.Size9), new SqlParameter("@pPrice9", material.Prices.Price9), new SqlParameter("@pModifiedBy", material.ModifiedBy) }; return(SqlDBHelper.ExecuteNonQuery("app_UpdateMaterials", CommandType.StoredProcedure, parameters)); } catch { return(false); } }
public bool AddNew(UserMaster _user) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserName", _user.UserName), new SqlParameter("@Password", _user.Password), new SqlParameter("@IsActive", _user.IsActive), new SqlParameter("@FirstName", _user.FirstName), new SqlParameter("@LastName", _user.LastName), new SqlParameter("@IsAdmin", _user.IsAdmin), new SqlParameter("@LoginDatetime", _user.LoginDatetime), new SqlParameter("@ModifiedDate", _user.ModifiedDate), new SqlParameter("@LastLoginDatetime", _user.LastLoginDatetime), new SqlParameter("@CreatedDate", _user.CreatedDate), new SqlParameter("@EmailId", _user.EmailId), }; return(SqlDBHelper.ExecuteNonQuery("proc_UserMaster_AddNew", CommandType.StoredProcedure, parameters)); }