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));
}
