//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated from a template.
//
//     Manual changes to this file may cause unexpected behavior in your application.
//     Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace Sainaatech
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;
    
    public partial class HMS : DbContext
    {
        public HMS()
            : base("name=HMS")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<tblAttaindanceMaster> tblAttaindanceMasters { get; set; }
        public virtual DbSet<tblDailyTaskEmployeeMaster> tblDailyTaskEmployeeMasters { get; set; }
        public virtual DbSet<tblDailyTaskMaster> tblDailyTaskMasters { get; set; }
        public virtual DbSet<tblDesignationMaster> tblDesignationMasters { get; set; }
        public virtual DbSet<tblEmployeeMaster> tblEmployeeMasters { get; set; }
        public virtual DbSet<tblEnquiryStatusMaster> tblEnquiryStatusMasters { get; set; }
        public virtual DbSet<tblExpensesHeadMaster> tblExpensesHeadMasters { get; set; }
        public virtual DbSet<tblExpensesMaster> tblExpensesMasters { get; set; }
        public virtual DbSet<tblExpensesSubHeadMaster> tblExpensesSubHeadMasters { get; set; }
        public virtual DbSet<tblExtraServicesMaster> tblExtraServicesMasters { get; set; }
        public virtual DbSet<tblFollowUpMaster> tblFollowUpMasters { get; set; }
        public virtual DbSet<tblHolidayMaster> tblHolidayMasters { get; set; }
        public virtual DbSet<tblIncomeExpensesSummaryMaster> tblIncomeExpensesSummaryMasters { get; set; }
        public virtual DbSet<tblJobMaster> tblJobMasters { get; set; }
        public virtual DbSet<tblLeaveMaster> tblLeaveMasters { get; set; }
        public virtual DbSet<tblLeaveTypeMaster> tblLeaveTypeMasters { get; set; }
        public virtual DbSet<tblParticularMaster> tblParticularMasters { get; set; }
        public virtual DbSet<tblPaymentMaster> tblPaymentMasters { get; set; }
        public virtual DbSet<tblPaymentSlabMaster> tblPaymentSlabMasters { get; set; }
        public virtual DbSet<tblProjectMaster> tblProjectMasters { get; set; }
        public virtual DbSet<tblProjectStatusMaster> tblProjectStatusMasters { get; set; }
        public virtual DbSet<tblPurchaseBillMaster> tblPurchaseBillMasters { get; set; }
        public virtual DbSet<tblQualificationMaster> tblQualificationMasters { get; set; }
        public virtual DbSet<tblSalaryMaster> tblSalaryMasters { get; set; }
        public virtual DbSet<tblStaffMaster> tblStaffMasters { get; set; }
        public virtual DbSet<tblStateMaster> tblStateMasters { get; set; }
        public virtual DbSet<tblStudent_Attendance_Master> tblStudent_Attendance_Master { get; set; }
        public virtual DbSet<tblSupportTypeMaster> tblSupportTypeMasters { get; set; }
        public virtual DbSet<tblTemplateMaster> tblTemplateMasters { get; set; }
        public virtual DbSet<tblTicketMaster> tblTicketMasters { get; set; }
        public virtual DbSet<tblWorkExperienceMaster> tblWorkExperienceMasters { get; set; }
        public virtual DbSet<weather_data> weather_data { get; set; }
    
        public virtual ObjectResult<sp_ClientPayment_Result> sp_ClientPayment(Nullable<int> cPUid, string pStatus, string transactionID, string refNo, Nullable<System.DateTime> requested, Nullable<int> pUid, string mRNumber, Nullable<System.DateTime> paymentDate, string paymentMode, string paymentFor, string paymentHead, Nullable<decimal> totalAmount, Nullable<decimal> paidAmount, Nullable<decimal> remainingAmount, string paymentOn, Nullable<decimal> gateway, string status, string action)
        {
            var cPUidParameter = cPUid.HasValue ?
                new ObjectParameter("CPUid", cPUid) :
                new ObjectParameter("CPUid", typeof(int));
    
            var pStatusParameter = pStatus != null ?
                new ObjectParameter("PStatus", pStatus) :
                new ObjectParameter("PStatus", typeof(string));
    
            var transactionIDParameter = transactionID != null ?
                new ObjectParameter("TransactionID", transactionID) :
                new ObjectParameter("TransactionID", typeof(string));
    
            var refNoParameter = refNo != null ?
                new ObjectParameter("RefNo", refNo) :
                new ObjectParameter("RefNo", typeof(string));
    
            var requestedParameter = requested.HasValue ?
                new ObjectParameter("Requested", requested) :
                new ObjectParameter("Requested", typeof(System.DateTime));
    
            var pUidParameter = pUid.HasValue ?
                new ObjectParameter("PUid", pUid) :
                new ObjectParameter("PUid", typeof(int));
    
            var mRNumberParameter = mRNumber != null ?
                new ObjectParameter("MRNumber", mRNumber) :
                new ObjectParameter("MRNumber", typeof(string));
    
            var paymentDateParameter = paymentDate.HasValue ?
                new ObjectParameter("PaymentDate", paymentDate) :
                new ObjectParameter("PaymentDate", typeof(System.DateTime));
    
            var paymentModeParameter = paymentMode != null ?
                new ObjectParameter("PaymentMode", paymentMode) :
                new ObjectParameter("PaymentMode", typeof(string));
    
            var paymentForParameter = paymentFor != null ?
                new ObjectParameter("PaymentFor", paymentFor) :
                new ObjectParameter("PaymentFor", typeof(string));
    
            var paymentHeadParameter = paymentHead != null ?
                new ObjectParameter("PaymentHead", paymentHead) :
                new ObjectParameter("PaymentHead", typeof(string));
    
            var totalAmountParameter = totalAmount.HasValue ?
                new ObjectParameter("TotalAmount", totalAmount) :
                new ObjectParameter("TotalAmount", typeof(decimal));
    
            var paidAmountParameter = paidAmount.HasValue ?
                new ObjectParameter("PaidAmount", paidAmount) :
                new ObjectParameter("PaidAmount", typeof(decimal));
    
            var remainingAmountParameter = remainingAmount.HasValue ?
                new ObjectParameter("RemainingAmount", remainingAmount) :
                new ObjectParameter("RemainingAmount", typeof(decimal));
    
            var paymentOnParameter = paymentOn != null ?
                new ObjectParameter("PaymentOn", paymentOn) :
                new ObjectParameter("PaymentOn", typeof(string));
    
            var gatewayParameter = gateway.HasValue ?
                new ObjectParameter("Gateway", gateway) :
                new ObjectParameter("Gateway", typeof(decimal));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_ClientPayment_Result>("sp_ClientPayment", cPUidParameter, pStatusParameter, transactionIDParameter, refNoParameter, requestedParameter, pUidParameter, mRNumberParameter, paymentDateParameter, paymentModeParameter, paymentForParameter, paymentHeadParameter, totalAmountParameter, paidAmountParameter, remainingAmountParameter, paymentOnParameter, gatewayParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_DailyAttaindance_Result> sp_DailyAttaindance(Nullable<int> aUid, Nullable<int> eUid, Nullable<System.DateTime> date, string aStatus, string status, string action)
        {
            var aUidParameter = aUid.HasValue ?
                new ObjectParameter("AUid", aUid) :
                new ObjectParameter("AUid", typeof(int));
    
            var eUidParameter = eUid.HasValue ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(int));
    
            var dateParameter = date.HasValue ?
                new ObjectParameter("Date", date) :
                new ObjectParameter("Date", typeof(System.DateTime));
    
            var aStatusParameter = aStatus != null ?
                new ObjectParameter("AStatus", aStatus) :
                new ObjectParameter("AStatus", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_DailyAttaindance_Result>("sp_DailyAttaindance", aUidParameter, eUidParameter, dateParameter, aStatusParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_DailyExpenses_Result> sp_DailyExpenses(Nullable<int> eUid, string voucherNo, Nullable<int> eSUid, Nullable<System.DateTime> paymentDate, string paymentMode, string paymentFor, Nullable<decimal> amount, string status, string action)
        {
            var eUidParameter = eUid.HasValue ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(int));
    
            var voucherNoParameter = voucherNo != null ?
                new ObjectParameter("VoucherNo", voucherNo) :
                new ObjectParameter("VoucherNo", typeof(string));
    
            var eSUidParameter = eSUid.HasValue ?
                new ObjectParameter("ESUid", eSUid) :
                new ObjectParameter("ESUid", typeof(int));
    
            var paymentDateParameter = paymentDate.HasValue ?
                new ObjectParameter("PaymentDate", paymentDate) :
                new ObjectParameter("PaymentDate", typeof(System.DateTime));
    
            var paymentModeParameter = paymentMode != null ?
                new ObjectParameter("PaymentMode", paymentMode) :
                new ObjectParameter("PaymentMode", typeof(string));
    
            var paymentForParameter = paymentFor != null ?
                new ObjectParameter("PaymentFor", paymentFor) :
                new ObjectParameter("PaymentFor", typeof(string));
    
            var amountParameter = amount.HasValue ?
                new ObjectParameter("Amount", amount) :
                new ObjectParameter("Amount", typeof(decimal));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_DailyExpenses_Result>("sp_DailyExpenses", eUidParameter, voucherNoParameter, eSUidParameter, paymentDateParameter, paymentModeParameter, paymentForParameter, amountParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_DailyTask_Result> sp_DailyTask(Nullable<int> dSUid, Nullable<int> eUid, Nullable<System.DateTime> date, Nullable<int> pUid, string remarks, string startTime, string endTime, Nullable<System.TimeSpan> hourWorked, Nullable<decimal> totalHour, Nullable<decimal> selfRating, string jobStatus, Nullable<decimal> managerRating, string attachment, string status, string action)
        {
            var dSUidParameter = dSUid.HasValue ?
                new ObjectParameter("DSUid", dSUid) :
                new ObjectParameter("DSUid", typeof(int));
    
            var eUidParameter = eUid.HasValue ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(int));
    
            var dateParameter = date.HasValue ?
                new ObjectParameter("Date", date) :
                new ObjectParameter("Date", typeof(System.DateTime));
    
            var pUidParameter = pUid.HasValue ?
                new ObjectParameter("PUid", pUid) :
                new ObjectParameter("PUid", typeof(int));
    
            var remarksParameter = remarks != null ?
                new ObjectParameter("Remarks", remarks) :
                new ObjectParameter("Remarks", typeof(string));
    
            var startTimeParameter = startTime != null ?
                new ObjectParameter("StartTime", startTime) :
                new ObjectParameter("StartTime", typeof(string));
    
            var endTimeParameter = endTime != null ?
                new ObjectParameter("EndTime", endTime) :
                new ObjectParameter("EndTime", typeof(string));
    
            var hourWorkedParameter = hourWorked.HasValue ?
                new ObjectParameter("HourWorked", hourWorked) :
                new ObjectParameter("HourWorked", typeof(System.TimeSpan));
    
            var totalHourParameter = totalHour.HasValue ?
                new ObjectParameter("TotalHour", totalHour) :
                new ObjectParameter("TotalHour", typeof(decimal));
    
            var selfRatingParameter = selfRating.HasValue ?
                new ObjectParameter("SelfRating", selfRating) :
                new ObjectParameter("SelfRating", typeof(decimal));
    
            var jobStatusParameter = jobStatus != null ?
                new ObjectParameter("JobStatus", jobStatus) :
                new ObjectParameter("JobStatus", typeof(string));
    
            var managerRatingParameter = managerRating.HasValue ?
                new ObjectParameter("ManagerRating", managerRating) :
                new ObjectParameter("ManagerRating", typeof(decimal));
    
            var attachmentParameter = attachment != null ?
                new ObjectParameter("Attachment", attachment) :
                new ObjectParameter("Attachment", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_DailyTask_Result>("sp_DailyTask", dSUidParameter, eUidParameter, dateParameter, pUidParameter, remarksParameter, startTimeParameter, endTimeParameter, hourWorkedParameter, totalHourParameter, selfRatingParameter, jobStatusParameter, managerRatingParameter, attachmentParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_DailyTaskAssign_Result> sp_DailyTaskAssign(Nullable<int> jUid, Nullable<int> eUid, Nullable<System.DateTime> assignedDate, string taskStatus, Nullable<System.DateTime> targetDate, string jobStatus, Nullable<int> pUid, string jobDetails, Nullable<int> assignedBy, Nullable<System.DateTime> jobStartedOn, Nullable<System.DateTime> jobCompletedOn, string jobCss, string priority, string status, string action)
        {
            var jUidParameter = jUid.HasValue ?
                new ObjectParameter("JUid", jUid) :
                new ObjectParameter("JUid", typeof(int));
    
            var eUidParameter = eUid.HasValue ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(int));
    
            var assignedDateParameter = assignedDate.HasValue ?
                new ObjectParameter("AssignedDate", assignedDate) :
                new ObjectParameter("AssignedDate", typeof(System.DateTime));
    
            var taskStatusParameter = taskStatus != null ?
                new ObjectParameter("TaskStatus", taskStatus) :
                new ObjectParameter("TaskStatus", typeof(string));
    
            var targetDateParameter = targetDate.HasValue ?
                new ObjectParameter("TargetDate", targetDate) :
                new ObjectParameter("TargetDate", typeof(System.DateTime));
    
            var jobStatusParameter = jobStatus != null ?
                new ObjectParameter("JobStatus", jobStatus) :
                new ObjectParameter("JobStatus", typeof(string));
    
            var pUidParameter = pUid.HasValue ?
                new ObjectParameter("PUid", pUid) :
                new ObjectParameter("PUid", typeof(int));
    
            var jobDetailsParameter = jobDetails != null ?
                new ObjectParameter("JobDetails", jobDetails) :
                new ObjectParameter("JobDetails", typeof(string));
    
            var assignedByParameter = assignedBy.HasValue ?
                new ObjectParameter("AssignedBy", assignedBy) :
                new ObjectParameter("AssignedBy", typeof(int));
    
            var jobStartedOnParameter = jobStartedOn.HasValue ?
                new ObjectParameter("JobStartedOn", jobStartedOn) :
                new ObjectParameter("JobStartedOn", typeof(System.DateTime));
    
            var jobCompletedOnParameter = jobCompletedOn.HasValue ?
                new ObjectParameter("JobCompletedOn", jobCompletedOn) :
                new ObjectParameter("JobCompletedOn", typeof(System.DateTime));
    
            var jobCssParameter = jobCss != null ?
                new ObjectParameter("JobCss", jobCss) :
                new ObjectParameter("JobCss", typeof(string));
    
            var priorityParameter = priority != null ?
                new ObjectParameter("Priority", priority) :
                new ObjectParameter("Priority", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_DailyTaskAssign_Result>("sp_DailyTaskAssign", jUidParameter, eUidParameter, assignedDateParameter, taskStatusParameter, targetDateParameter, jobStatusParameter, pUidParameter, jobDetailsParameter, assignedByParameter, jobStartedOnParameter, jobCompletedOnParameter, jobCssParameter, priorityParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_DailyTaskEmployee_Result> sp_DailyTaskEmployee(Nullable<int> dTUid, Nullable<int> jUid, Nullable<int> eUid, Nullable<System.DateTime> date, Nullable<int> pUid, string remarks, string startTime, string endTime, Nullable<System.TimeSpan> hourWorked, Nullable<decimal> totalHour, Nullable<decimal> selfRating, string jobStatus, Nullable<decimal> managerRating, string attachment, string managerRemarks, string status, string action)
        {
            var dTUidParameter = dTUid.HasValue ?
                new ObjectParameter("DTUid", dTUid) :
                new ObjectParameter("DTUid", typeof(int));
    
            var jUidParameter = jUid.HasValue ?
                new ObjectParameter("JUid", jUid) :
                new ObjectParameter("JUid", typeof(int));
    
            var eUidParameter = eUid.HasValue ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(int));
    
            var dateParameter = date.HasValue ?
                new ObjectParameter("Date", date) :
                new ObjectParameter("Date", typeof(System.DateTime));
    
            var pUidParameter = pUid.HasValue ?
                new ObjectParameter("PUid", pUid) :
                new ObjectParameter("PUid", typeof(int));
    
            var remarksParameter = remarks != null ?
                new ObjectParameter("Remarks", remarks) :
                new ObjectParameter("Remarks", typeof(string));
    
            var startTimeParameter = startTime != null ?
                new ObjectParameter("StartTime", startTime) :
                new ObjectParameter("StartTime", typeof(string));
    
            var endTimeParameter = endTime != null ?
                new ObjectParameter("EndTime", endTime) :
                new ObjectParameter("EndTime", typeof(string));
    
            var hourWorkedParameter = hourWorked.HasValue ?
                new ObjectParameter("HourWorked", hourWorked) :
                new ObjectParameter("HourWorked", typeof(System.TimeSpan));
    
            var totalHourParameter = totalHour.HasValue ?
                new ObjectParameter("TotalHour", totalHour) :
                new ObjectParameter("TotalHour", typeof(decimal));
    
            var selfRatingParameter = selfRating.HasValue ?
                new ObjectParameter("SelfRating", selfRating) :
                new ObjectParameter("SelfRating", typeof(decimal));
    
            var jobStatusParameter = jobStatus != null ?
                new ObjectParameter("JobStatus", jobStatus) :
                new ObjectParameter("JobStatus", typeof(string));
    
            var managerRatingParameter = managerRating.HasValue ?
                new ObjectParameter("ManagerRating", managerRating) :
                new ObjectParameter("ManagerRating", typeof(decimal));
    
            var attachmentParameter = attachment != null ?
                new ObjectParameter("Attachment", attachment) :
                new ObjectParameter("Attachment", typeof(string));
    
            var managerRemarksParameter = managerRemarks != null ?
                new ObjectParameter("ManagerRemarks", managerRemarks) :
                new ObjectParameter("ManagerRemarks", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_DailyTaskEmployee_Result>("sp_DailyTaskEmployee", dTUidParameter, jUidParameter, eUidParameter, dateParameter, pUidParameter, remarksParameter, startTimeParameter, endTimeParameter, hourWorkedParameter, totalHourParameter, selfRatingParameter, jobStatusParameter, managerRatingParameter, attachmentParameter, managerRemarksParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_Designation_Result> sp_Designation(Nullable<int> designationUid, string designation, string status, string action)
        {
            var designationUidParameter = designationUid.HasValue ?
                new ObjectParameter("DesignationUid", designationUid) :
                new ObjectParameter("DesignationUid", typeof(int));
    
            var designationParameter = designation != null ?
                new ObjectParameter("Designation", designation) :
                new ObjectParameter("Designation", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_Designation_Result>("sp_Designation", designationUidParameter, designationParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_EmployeeLeave_Result> sp_EmployeeLeave(Nullable<int> lUid, Nullable<int> eUid, Nullable<int> lTUid, Nullable<System.DateTime> applyDate, Nullable<System.DateTime> leaveDate, string reason, string lStatus, string status, Nullable<System.DateTime> approvedDate, Nullable<System.DateTime> approvedDateTime, string action)
        {
            var lUidParameter = lUid.HasValue ?
                new ObjectParameter("LUid", lUid) :
                new ObjectParameter("LUid", typeof(int));
    
            var eUidParameter = eUid.HasValue ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(int));
    
            var lTUidParameter = lTUid.HasValue ?
                new ObjectParameter("LTUid", lTUid) :
                new ObjectParameter("LTUid", typeof(int));
    
            var applyDateParameter = applyDate.HasValue ?
                new ObjectParameter("ApplyDate", applyDate) :
                new ObjectParameter("ApplyDate", typeof(System.DateTime));
    
            var leaveDateParameter = leaveDate.HasValue ?
                new ObjectParameter("LeaveDate", leaveDate) :
                new ObjectParameter("LeaveDate", typeof(System.DateTime));
    
            var reasonParameter = reason != null ?
                new ObjectParameter("Reason", reason) :
                new ObjectParameter("Reason", typeof(string));
    
            var lStatusParameter = lStatus != null ?
                new ObjectParameter("LStatus", lStatus) :
                new ObjectParameter("LStatus", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var approvedDateParameter = approvedDate.HasValue ?
                new ObjectParameter("ApprovedDate", approvedDate) :
                new ObjectParameter("ApprovedDate", typeof(System.DateTime));
    
            var approvedDateTimeParameter = approvedDateTime.HasValue ?
                new ObjectParameter("ApprovedDateTime", approvedDateTime) :
                new ObjectParameter("ApprovedDateTime", typeof(System.DateTime));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_EmployeeLeave_Result>("sp_EmployeeLeave", lUidParameter, eUidParameter, lTUidParameter, applyDateParameter, leaveDateParameter, reasonParameter, lStatusParameter, statusParameter, approvedDateParameter, approvedDateTimeParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_EmployeeRegd_Result> sp_EmployeeRegd(Nullable<int> eUid, Nullable<int> cookies, string photo, string employeeID, string name, string email, string password, Nullable<int> qUid, string mobile, string gender, Nullable<int> designationUid, Nullable<int> wEUid, string userType, Nullable<System.DateTime> dateOfBirth, Nullable<System.DateTime> dateOfJoining, string guardianName, string guardianMobile, string presentAddress, string permaanentAddress, string bankName, string iFSC, string basicSalary, string accountNo, string status, string action)
        {
            var eUidParameter = eUid.HasValue ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(int));
    
            var cookiesParameter = cookies.HasValue ?
                new ObjectParameter("Cookies", cookies) :
                new ObjectParameter("Cookies", typeof(int));
    
            var photoParameter = photo != null ?
                new ObjectParameter("Photo", photo) :
                new ObjectParameter("Photo", typeof(string));
    
            var employeeIDParameter = employeeID != null ?
                new ObjectParameter("EmployeeID", employeeID) :
                new ObjectParameter("EmployeeID", typeof(string));
    
            var nameParameter = name != null ?
                new ObjectParameter("Name", name) :
                new ObjectParameter("Name", typeof(string));
    
            var emailParameter = email != null ?
                new ObjectParameter("Email", email) :
                new ObjectParameter("Email", typeof(string));
    
            var passwordParameter = password != null ?
                new ObjectParameter("Password", password) :
                new ObjectParameter("Password", typeof(string));
    
            var qUidParameter = qUid.HasValue ?
                new ObjectParameter("QUid", qUid) :
                new ObjectParameter("QUid", typeof(int));
    
            var mobileParameter = mobile != null ?
                new ObjectParameter("Mobile", mobile) :
                new ObjectParameter("Mobile", typeof(string));
    
            var genderParameter = gender != null ?
                new ObjectParameter("Gender", gender) :
                new ObjectParameter("Gender", typeof(string));
    
            var designationUidParameter = designationUid.HasValue ?
                new ObjectParameter("DesignationUid", designationUid) :
                new ObjectParameter("DesignationUid", typeof(int));
    
            var wEUidParameter = wEUid.HasValue ?
                new ObjectParameter("WEUid", wEUid) :
                new ObjectParameter("WEUid", typeof(int));
    
            var userTypeParameter = userType != null ?
                new ObjectParameter("UserType", userType) :
                new ObjectParameter("UserType", typeof(string));
    
            var dateOfBirthParameter = dateOfBirth.HasValue ?
                new ObjectParameter("DateOfBirth", dateOfBirth) :
                new ObjectParameter("DateOfBirth", typeof(System.DateTime));
    
            var dateOfJoiningParameter = dateOfJoining.HasValue ?
                new ObjectParameter("DateOfJoining", dateOfJoining) :
                new ObjectParameter("DateOfJoining", typeof(System.DateTime));
    
            var guardianNameParameter = guardianName != null ?
                new ObjectParameter("GuardianName", guardianName) :
                new ObjectParameter("GuardianName", typeof(string));
    
            var guardianMobileParameter = guardianMobile != null ?
                new ObjectParameter("GuardianMobile", guardianMobile) :
                new ObjectParameter("GuardianMobile", typeof(string));
    
            var presentAddressParameter = presentAddress != null ?
                new ObjectParameter("PresentAddress", presentAddress) :
                new ObjectParameter("PresentAddress", typeof(string));
    
            var permaanentAddressParameter = permaanentAddress != null ?
                new ObjectParameter("PermaanentAddress", permaanentAddress) :
                new ObjectParameter("PermaanentAddress", typeof(string));
    
            var bankNameParameter = bankName != null ?
                new ObjectParameter("BankName", bankName) :
                new ObjectParameter("BankName", typeof(string));
    
            var iFSCParameter = iFSC != null ?
                new ObjectParameter("IFSC", iFSC) :
                new ObjectParameter("IFSC", typeof(string));
    
            var basicSalaryParameter = basicSalary != null ?
                new ObjectParameter("BasicSalary", basicSalary) :
                new ObjectParameter("BasicSalary", typeof(string));
    
            var accountNoParameter = accountNo != null ?
                new ObjectParameter("AccountNo", accountNo) :
                new ObjectParameter("AccountNo", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_EmployeeRegd_Result>("sp_EmployeeRegd", eUidParameter, cookiesParameter, photoParameter, employeeIDParameter, nameParameter, emailParameter, passwordParameter, qUidParameter, mobileParameter, genderParameter, designationUidParameter, wEUidParameter, userTypeParameter, dateOfBirthParameter, dateOfJoiningParameter, guardianNameParameter, guardianMobileParameter, presentAddressParameter, permaanentAddressParameter, bankNameParameter, iFSCParameter, basicSalaryParameter, accountNoParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_EnquiryStatusMasterManagement_Result> sp_EnquiryStatusMasterManagement(Nullable<int> eSUid, string name, string status, string action)
        {
            var eSUidParameter = eSUid.HasValue ?
                new ObjectParameter("ESUid", eSUid) :
                new ObjectParameter("ESUid", typeof(int));
    
            var nameParameter = name != null ?
                new ObjectParameter("Name", name) :
                new ObjectParameter("Name", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_EnquiryStatusMasterManagement_Result>("sp_EnquiryStatusMasterManagement", eSUidParameter, nameParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_ExpensesHead_Result> sp_ExpensesHead(Nullable<int> eHUid, string headName, string status, string action)
        {
            var eHUidParameter = eHUid.HasValue ?
                new ObjectParameter("EHUid", eHUid) :
                new ObjectParameter("EHUid", typeof(int));
    
            var headNameParameter = headName != null ?
                new ObjectParameter("HeadName", headName) :
                new ObjectParameter("HeadName", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_ExpensesHead_Result>("sp_ExpensesHead", eHUidParameter, headNameParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_ExpensesSubHead_Result> sp_ExpensesSubHead(Nullable<int> eSUid, Nullable<int> eHUid, string headName, string status, string action)
        {
            var eSUidParameter = eSUid.HasValue ?
                new ObjectParameter("ESUid", eSUid) :
                new ObjectParameter("ESUid", typeof(int));
    
            var eHUidParameter = eHUid.HasValue ?
                new ObjectParameter("EHUid", eHUid) :
                new ObjectParameter("EHUid", typeof(int));
    
            var headNameParameter = headName != null ?
                new ObjectParameter("HeadName", headName) :
                new ObjectParameter("HeadName", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_ExpensesSubHead_Result>("sp_ExpensesSubHead", eSUidParameter, eHUidParameter, headNameParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_ExtraServices_Result> sp_ExtraServices(Nullable<int> eSUid, Nullable<int> pUid, Nullable<System.DateTime> startDate, Nullable<System.DateTime> completedDate, Nullable<System.DateTime> renewalDate, string licenseNo, Nullable<decimal> projectCost, Nullable<decimal> gSTAmount, Nullable<decimal> renewalCost, string quotation, string bill, string status, string action)
        {
            var eSUidParameter = eSUid.HasValue ?
                new ObjectParameter("ESUid", eSUid) :
                new ObjectParameter("ESUid", typeof(int));
    
            var pUidParameter = pUid.HasValue ?
                new ObjectParameter("PUid", pUid) :
                new ObjectParameter("PUid", typeof(int));
    
            var startDateParameter = startDate.HasValue ?
                new ObjectParameter("StartDate", startDate) :
                new ObjectParameter("StartDate", typeof(System.DateTime));
    
            var completedDateParameter = completedDate.HasValue ?
                new ObjectParameter("CompletedDate", completedDate) :
                new ObjectParameter("CompletedDate", typeof(System.DateTime));
    
            var renewalDateParameter = renewalDate.HasValue ?
                new ObjectParameter("RenewalDate", renewalDate) :
                new ObjectParameter("RenewalDate", typeof(System.DateTime));
    
            var licenseNoParameter = licenseNo != null ?
                new ObjectParameter("LicenseNo", licenseNo) :
                new ObjectParameter("LicenseNo", typeof(string));
    
            var projectCostParameter = projectCost.HasValue ?
                new ObjectParameter("ProjectCost", projectCost) :
                new ObjectParameter("ProjectCost", typeof(decimal));
    
            var gSTAmountParameter = gSTAmount.HasValue ?
                new ObjectParameter("GSTAmount", gSTAmount) :
                new ObjectParameter("GSTAmount", typeof(decimal));
    
            var renewalCostParameter = renewalCost.HasValue ?
                new ObjectParameter("RenewalCost", renewalCost) :
                new ObjectParameter("RenewalCost", typeof(decimal));
    
            var quotationParameter = quotation != null ?
                new ObjectParameter("Quotation", quotation) :
                new ObjectParameter("Quotation", typeof(string));
    
            var billParameter = bill != null ?
                new ObjectParameter("Bill", bill) :
                new ObjectParameter("Bill", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_ExtraServices_Result>("sp_ExtraServices", eSUidParameter, pUidParameter, startDateParameter, completedDateParameter, renewalDateParameter, licenseNoParameter, projectCostParameter, gSTAmountParameter, renewalCostParameter, quotationParameter, billParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_FollowUpMasterManagement_Result> sp_FollowUpMasterManagement(Nullable<int> fUid, Nullable<int> empUid, Nullable<int> eSUid, string name, string mobile, string address, Nullable<System.DateTime> dateOfCall, Nullable<System.DateTime> followUpDate, string followUpTime, string interestedFor, string remarks, string status, string action)
        {
            var fUidParameter = fUid.HasValue ?
                new ObjectParameter("FUid", fUid) :
                new ObjectParameter("FUid", typeof(int));
    
            var empUidParameter = empUid.HasValue ?
                new ObjectParameter("EmpUid", empUid) :
                new ObjectParameter("EmpUid", typeof(int));
    
            var eSUidParameter = eSUid.HasValue ?
                new ObjectParameter("ESUid", eSUid) :
                new ObjectParameter("ESUid", typeof(int));
    
            var nameParameter = name != null ?
                new ObjectParameter("Name", name) :
                new ObjectParameter("Name", typeof(string));
    
            var mobileParameter = mobile != null ?
                new ObjectParameter("Mobile", mobile) :
                new ObjectParameter("Mobile", typeof(string));
    
            var addressParameter = address != null ?
                new ObjectParameter("Address", address) :
                new ObjectParameter("Address", typeof(string));
    
            var dateOfCallParameter = dateOfCall.HasValue ?
                new ObjectParameter("DateOfCall", dateOfCall) :
                new ObjectParameter("DateOfCall", typeof(System.DateTime));
    
            var followUpDateParameter = followUpDate.HasValue ?
                new ObjectParameter("FollowUpDate", followUpDate) :
                new ObjectParameter("FollowUpDate", typeof(System.DateTime));
    
            var followUpTimeParameter = followUpTime != null ?
                new ObjectParameter("FollowUpTime", followUpTime) :
                new ObjectParameter("FollowUpTime", typeof(string));
    
            var interestedForParameter = interestedFor != null ?
                new ObjectParameter("InterestedFor", interestedFor) :
                new ObjectParameter("InterestedFor", typeof(string));
    
            var remarksParameter = remarks != null ?
                new ObjectParameter("Remarks", remarks) :
                new ObjectParameter("Remarks", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_FollowUpMasterManagement_Result>("sp_FollowUpMasterManagement", fUidParameter, empUidParameter, eSUidParameter, nameParameter, mobileParameter, addressParameter, dateOfCallParameter, followUpDateParameter, followUpTimeParameter, interestedForParameter, remarksParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_Holiday_Result> sp_Holiday(Nullable<int> hUid, Nullable<System.DateTime> date, string holidayFor, string status, string action)
        {
            var hUidParameter = hUid.HasValue ?
                new ObjectParameter("HUid", hUid) :
                new ObjectParameter("HUid", typeof(int));
    
            var dateParameter = date.HasValue ?
                new ObjectParameter("Date", date) :
                new ObjectParameter("Date", typeof(System.DateTime));
    
            var holidayForParameter = holidayFor != null ?
                new ObjectParameter("HolidayFor", holidayFor) :
                new ObjectParameter("HolidayFor", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_Holiday_Result>("sp_Holiday", hUidParameter, dateParameter, holidayForParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_Particular_Result> sp_Particular(Nullable<int> pHUid, string headName, string status, string action)
        {
            var pHUidParameter = pHUid.HasValue ?
                new ObjectParameter("PHUid", pHUid) :
                new ObjectParameter("PHUid", typeof(int));
    
            var headNameParameter = headName != null ?
                new ObjectParameter("HeadName", headName) :
                new ObjectParameter("HeadName", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_Particular_Result>("sp_Particular", pHUidParameter, headNameParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_Project_Result> sp_Project(Nullable<int> pUid, Nullable<int> pSUid, Nullable<int> pLUid, string projectName, string clientName, Nullable<System.DateTime> startDate, Nullable<System.DateTime> completedDate, Nullable<System.DateTime> renewalDate, string mobile, string email, string password, string address, string regdNo, string licenseNo, string gSTNo, string businessType, Nullable<decimal> projectCost, Nullable<decimal> gSTAmount, Nullable<decimal> renewalCost, string quotation, string bill, string status, string fTP_IP_Address, string fTP_Name, string fTP_Password, string database_IP_Address, string database_Name, string database_UserID, string database_Password, string website, string eUid, Nullable<int> stateUid, string renewType, Nullable<int> slabUid, string action)
        {
            var pUidParameter = pUid.HasValue ?
                new ObjectParameter("PUid", pUid) :
                new ObjectParameter("PUid", typeof(int));
    
            var pSUidParameter = pSUid.HasValue ?
                new ObjectParameter("PSUid", pSUid) :
                new ObjectParameter("PSUid", typeof(int));
    
            var pLUidParameter = pLUid.HasValue ?
                new ObjectParameter("PLUid", pLUid) :
                new ObjectParameter("PLUid", typeof(int));
    
            var projectNameParameter = projectName != null ?
                new ObjectParameter("ProjectName", projectName) :
                new ObjectParameter("ProjectName", typeof(string));
    
            var clientNameParameter = clientName != null ?
                new ObjectParameter("ClientName", clientName) :
                new ObjectParameter("ClientName", typeof(string));
    
            var startDateParameter = startDate.HasValue ?
                new ObjectParameter("StartDate", startDate) :
                new ObjectParameter("StartDate", typeof(System.DateTime));
    
            var completedDateParameter = completedDate.HasValue ?
                new ObjectParameter("CompletedDate", completedDate) :
                new ObjectParameter("CompletedDate", typeof(System.DateTime));
    
            var renewalDateParameter = renewalDate.HasValue ?
                new ObjectParameter("RenewalDate", renewalDate) :
                new ObjectParameter("RenewalDate", typeof(System.DateTime));
    
            var mobileParameter = mobile != null ?
                new ObjectParameter("Mobile", mobile) :
                new ObjectParameter("Mobile", typeof(string));
    
            var emailParameter = email != null ?
                new ObjectParameter("Email", email) :
                new ObjectParameter("Email", typeof(string));
    
            var passwordParameter = password != null ?
                new ObjectParameter("Password", password) :
                new ObjectParameter("Password", typeof(string));
    
            var addressParameter = address != null ?
                new ObjectParameter("Address", address) :
                new ObjectParameter("Address", typeof(string));
    
            var regdNoParameter = regdNo != null ?
                new ObjectParameter("RegdNo", regdNo) :
                new ObjectParameter("RegdNo", typeof(string));
    
            var licenseNoParameter = licenseNo != null ?
                new ObjectParameter("LicenseNo", licenseNo) :
                new ObjectParameter("LicenseNo", typeof(string));
    
            var gSTNoParameter = gSTNo != null ?
                new ObjectParameter("GSTNo", gSTNo) :
                new ObjectParameter("GSTNo", typeof(string));
    
            var businessTypeParameter = businessType != null ?
                new ObjectParameter("BusinessType", businessType) :
                new ObjectParameter("BusinessType", typeof(string));
    
            var projectCostParameter = projectCost.HasValue ?
                new ObjectParameter("ProjectCost", projectCost) :
                new ObjectParameter("ProjectCost", typeof(decimal));
    
            var gSTAmountParameter = gSTAmount.HasValue ?
                new ObjectParameter("GSTAmount", gSTAmount) :
                new ObjectParameter("GSTAmount", typeof(decimal));
    
            var renewalCostParameter = renewalCost.HasValue ?
                new ObjectParameter("RenewalCost", renewalCost) :
                new ObjectParameter("RenewalCost", typeof(decimal));
    
            var quotationParameter = quotation != null ?
                new ObjectParameter("Quotation", quotation) :
                new ObjectParameter("Quotation", typeof(string));
    
            var billParameter = bill != null ?
                new ObjectParameter("Bill", bill) :
                new ObjectParameter("Bill", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var fTP_IP_AddressParameter = fTP_IP_Address != null ?
                new ObjectParameter("FTP_IP_Address", fTP_IP_Address) :
                new ObjectParameter("FTP_IP_Address", typeof(string));
    
            var fTP_NameParameter = fTP_Name != null ?
                new ObjectParameter("FTP_Name", fTP_Name) :
                new ObjectParameter("FTP_Name", typeof(string));
    
            var fTP_PasswordParameter = fTP_Password != null ?
                new ObjectParameter("FTP_Password", fTP_Password) :
                new ObjectParameter("FTP_Password", typeof(string));
    
            var database_IP_AddressParameter = database_IP_Address != null ?
                new ObjectParameter("Database_IP_Address", database_IP_Address) :
                new ObjectParameter("Database_IP_Address", typeof(string));
    
            var database_NameParameter = database_Name != null ?
                new ObjectParameter("Database_Name", database_Name) :
                new ObjectParameter("Database_Name", typeof(string));
    
            var database_UserIDParameter = database_UserID != null ?
                new ObjectParameter("Database_UserID", database_UserID) :
                new ObjectParameter("Database_UserID", typeof(string));
    
            var database_PasswordParameter = database_Password != null ?
                new ObjectParameter("Database_Password", database_Password) :
                new ObjectParameter("Database_Password", typeof(string));
    
            var websiteParameter = website != null ?
                new ObjectParameter("Website", website) :
                new ObjectParameter("Website", typeof(string));
    
            var eUidParameter = eUid != null ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(string));
    
            var stateUidParameter = stateUid.HasValue ?
                new ObjectParameter("StateUid", stateUid) :
                new ObjectParameter("StateUid", typeof(int));
    
            var renewTypeParameter = renewType != null ?
                new ObjectParameter("RenewType", renewType) :
                new ObjectParameter("RenewType", typeof(string));
    
            var slabUidParameter = slabUid.HasValue ?
                new ObjectParameter("SlabUid", slabUid) :
                new ObjectParameter("SlabUid", typeof(int));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_Project_Result>("sp_Project", pUidParameter, pSUidParameter, pLUidParameter, projectNameParameter, clientNameParameter, startDateParameter, completedDateParameter, renewalDateParameter, mobileParameter, emailParameter, passwordParameter, addressParameter, regdNoParameter, licenseNoParameter, gSTNoParameter, businessTypeParameter, projectCostParameter, gSTAmountParameter, renewalCostParameter, quotationParameter, billParameter, statusParameter, fTP_IP_AddressParameter, fTP_NameParameter, fTP_PasswordParameter, database_IP_AddressParameter, database_NameParameter, database_UserIDParameter, database_PasswordParameter, websiteParameter, eUidParameter, stateUidParameter, renewTypeParameter, slabUidParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_PurchaseBill_Result> sp_PurchaseBill(Nullable<int> pBUid, string bill, Nullable<System.DateTime> invoiceDate, string invoiceNo, string partyName, string gSTNo, string mobile, string email, string address, string transactionType, Nullable<decimal> rate, Nullable<decimal> amount, Nullable<decimal> cGST, Nullable<decimal> sGST, Nullable<decimal> central, Nullable<int> stateUid, string status, string action)
        {
            var pBUidParameter = pBUid.HasValue ?
                new ObjectParameter("PBUid", pBUid) :
                new ObjectParameter("PBUid", typeof(int));
    
            var billParameter = bill != null ?
                new ObjectParameter("Bill", bill) :
                new ObjectParameter("Bill", typeof(string));
    
            var invoiceDateParameter = invoiceDate.HasValue ?
                new ObjectParameter("InvoiceDate", invoiceDate) :
                new ObjectParameter("InvoiceDate", typeof(System.DateTime));
    
            var invoiceNoParameter = invoiceNo != null ?
                new ObjectParameter("InvoiceNo", invoiceNo) :
                new ObjectParameter("InvoiceNo", typeof(string));
    
            var partyNameParameter = partyName != null ?
                new ObjectParameter("PartyName", partyName) :
                new ObjectParameter("PartyName", typeof(string));
    
            var gSTNoParameter = gSTNo != null ?
                new ObjectParameter("GSTNo", gSTNo) :
                new ObjectParameter("GSTNo", typeof(string));
    
            var mobileParameter = mobile != null ?
                new ObjectParameter("Mobile", mobile) :
                new ObjectParameter("Mobile", typeof(string));
    
            var emailParameter = email != null ?
                new ObjectParameter("Email", email) :
                new ObjectParameter("Email", typeof(string));
    
            var addressParameter = address != null ?
                new ObjectParameter("Address", address) :
                new ObjectParameter("Address", typeof(string));
    
            var transactionTypeParameter = transactionType != null ?
                new ObjectParameter("TransactionType", transactionType) :
                new ObjectParameter("TransactionType", typeof(string));
    
            var rateParameter = rate.HasValue ?
                new ObjectParameter("Rate", rate) :
                new ObjectParameter("Rate", typeof(decimal));
    
            var amountParameter = amount.HasValue ?
                new ObjectParameter("Amount", amount) :
                new ObjectParameter("Amount", typeof(decimal));
    
            var cGSTParameter = cGST.HasValue ?
                new ObjectParameter("CGST", cGST) :
                new ObjectParameter("CGST", typeof(decimal));
    
            var sGSTParameter = sGST.HasValue ?
                new ObjectParameter("SGST", sGST) :
                new ObjectParameter("SGST", typeof(decimal));
    
            var centralParameter = central.HasValue ?
                new ObjectParameter("Central", central) :
                new ObjectParameter("Central", typeof(decimal));
    
            var stateUidParameter = stateUid.HasValue ?
                new ObjectParameter("StateUid", stateUid) :
                new ObjectParameter("StateUid", typeof(int));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_PurchaseBill_Result>("sp_PurchaseBill", pBUidParameter, billParameter, invoiceDateParameter, invoiceNoParameter, partyNameParameter, gSTNoParameter, mobileParameter, emailParameter, addressParameter, transactionTypeParameter, rateParameter, amountParameter, cGSTParameter, sGSTParameter, centralParameter, stateUidParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_Qualification_Result> sp_Qualification(Nullable<int> qUid, string qualification, string status, string action)
        {
            var qUidParameter = qUid.HasValue ?
                new ObjectParameter("QUid", qUid) :
                new ObjectParameter("QUid", typeof(int));
    
            var qualificationParameter = qualification != null ?
                new ObjectParameter("Qualification", qualification) :
                new ObjectParameter("Qualification", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_Qualification_Result>("sp_Qualification", qUidParameter, qualificationParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_SalaryMaster_Result> sp_SalaryMaster(Nullable<int> salaryUid, Nullable<int> eUid, Nullable<decimal> basicSalary, Nullable<decimal> advance, Nullable<decimal> lWP, Nullable<decimal> oT, Nullable<decimal> performance, Nullable<System.DateTime> paymentDate, string salaryMonth, string salaryYear, Nullable<decimal> totalSalary, Nullable<decimal> totalDeduction, Nullable<decimal> netSalary, Nullable<decimal> daysWorked, string status, string action)
        {
            var salaryUidParameter = salaryUid.HasValue ?
                new ObjectParameter("SalaryUid", salaryUid) :
                new ObjectParameter("SalaryUid", typeof(int));
    
            var eUidParameter = eUid.HasValue ?
                new ObjectParameter("EUid", eUid) :
                new ObjectParameter("EUid", typeof(int));
    
            var basicSalaryParameter = basicSalary.HasValue ?
                new ObjectParameter("BasicSalary", basicSalary) :
                new ObjectParameter("BasicSalary", typeof(decimal));
    
            var advanceParameter = advance.HasValue ?
                new ObjectParameter("Advance", advance) :
                new ObjectParameter("Advance", typeof(decimal));
    
            var lWPParameter = lWP.HasValue ?
                new ObjectParameter("LWP", lWP) :
                new ObjectParameter("LWP", typeof(decimal));
    
            var oTParameter = oT.HasValue ?
                new ObjectParameter("OT", oT) :
                new ObjectParameter("OT", typeof(decimal));
    
            var performanceParameter = performance.HasValue ?
                new ObjectParameter("Performance", performance) :
                new ObjectParameter("Performance", typeof(decimal));
    
            var paymentDateParameter = paymentDate.HasValue ?
                new ObjectParameter("PaymentDate", paymentDate) :
                new ObjectParameter("PaymentDate", typeof(System.DateTime));
    
            var salaryMonthParameter = salaryMonth != null ?
                new ObjectParameter("SalaryMonth", salaryMonth) :
                new ObjectParameter("SalaryMonth", typeof(string));
    
            var salaryYearParameter = salaryYear != null ?
                new ObjectParameter("SalaryYear", salaryYear) :
                new ObjectParameter("SalaryYear", typeof(string));
    
            var totalSalaryParameter = totalSalary.HasValue ?
                new ObjectParameter("TotalSalary", totalSalary) :
                new ObjectParameter("TotalSalary", typeof(decimal));
    
            var totalDeductionParameter = totalDeduction.HasValue ?
                new ObjectParameter("TotalDeduction", totalDeduction) :
                new ObjectParameter("TotalDeduction", typeof(decimal));
    
            var netSalaryParameter = netSalary.HasValue ?
                new ObjectParameter("NetSalary", netSalary) :
                new ObjectParameter("NetSalary", typeof(decimal));
    
            var daysWorkedParameter = daysWorked.HasValue ?
                new ObjectParameter("DaysWorked", daysWorked) :
                new ObjectParameter("DaysWorked", typeof(decimal));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_SalaryMaster_Result>("sp_SalaryMaster", salaryUidParameter, eUidParameter, basicSalaryParameter, advanceParameter, lWPParameter, oTParameter, performanceParameter, paymentDateParameter, salaryMonthParameter, salaryYearParameter, totalSalaryParameter, totalDeductionParameter, netSalaryParameter, daysWorkedParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> sp_StudentAttendance(Nullable<int> sUid, string dS, string pia_id, string pia_name, string centre_id, string centre_name, string batch_id, string batch_name, string candidate_id, string candidate_name, string attendance_status, string attendance_in_date_time, string attendance_out_date_time, string attendance_date, string status, string action)
        {
            var sUidParameter = sUid.HasValue ?
                new ObjectParameter("SUid", sUid) :
                new ObjectParameter("SUid", typeof(int));
    
            var dSParameter = dS != null ?
                new ObjectParameter("DS", dS) :
                new ObjectParameter("DS", typeof(string));
    
            var pia_idParameter = pia_id != null ?
                new ObjectParameter("pia_id", pia_id) :
                new ObjectParameter("pia_id", typeof(string));
    
            var pia_nameParameter = pia_name != null ?
                new ObjectParameter("pia_name", pia_name) :
                new ObjectParameter("pia_name", typeof(string));
    
            var centre_idParameter = centre_id != null ?
                new ObjectParameter("centre_id", centre_id) :
                new ObjectParameter("centre_id", typeof(string));
    
            var centre_nameParameter = centre_name != null ?
                new ObjectParameter("centre_name", centre_name) :
                new ObjectParameter("centre_name", typeof(string));
    
            var batch_idParameter = batch_id != null ?
                new ObjectParameter("batch_id", batch_id) :
                new ObjectParameter("batch_id", typeof(string));
    
            var batch_nameParameter = batch_name != null ?
                new ObjectParameter("batch_name", batch_name) :
                new ObjectParameter("batch_name", typeof(string));
    
            var candidate_idParameter = candidate_id != null ?
                new ObjectParameter("candidate_id", candidate_id) :
                new ObjectParameter("candidate_id", typeof(string));
    
            var candidate_nameParameter = candidate_name != null ?
                new ObjectParameter("candidate_name", candidate_name) :
                new ObjectParameter("candidate_name", typeof(string));
    
            var attendance_statusParameter = attendance_status != null ?
                new ObjectParameter("attendance_status", attendance_status) :
                new ObjectParameter("attendance_status", typeof(string));
    
            var attendance_in_date_timeParameter = attendance_in_date_time != null ?
                new ObjectParameter("attendance_in_date_time", attendance_in_date_time) :
                new ObjectParameter("attendance_in_date_time", typeof(string));
    
            var attendance_out_date_timeParameter = attendance_out_date_time != null ?
                new ObjectParameter("attendance_out_date_time", attendance_out_date_time) :
                new ObjectParameter("attendance_out_date_time", typeof(string));
    
            var attendance_dateParameter = attendance_date != null ?
                new ObjectParameter("attendance_date", attendance_date) :
                new ObjectParameter("attendance_date", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("sp_StudentAttendance", sUidParameter, dSParameter, pia_idParameter, pia_nameParameter, centre_idParameter, centre_nameParameter, batch_idParameter, batch_nameParameter, candidate_idParameter, candidate_nameParameter, attendance_statusParameter, attendance_in_date_timeParameter, attendance_out_date_timeParameter, attendance_dateParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_SupportType_Result> sp_SupportType(Nullable<int> sTUid, string supportType, string status, string action)
        {
            var sTUidParameter = sTUid.HasValue ?
                new ObjectParameter("STUid", sTUid) :
                new ObjectParameter("STUid", typeof(int));
    
            var supportTypeParameter = supportType != null ?
                new ObjectParameter("SupportType", supportType) :
                new ObjectParameter("SupportType", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_SupportType_Result>("sp_SupportType", sTUidParameter, supportTypeParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_Template_Result> sp_Template(Nullable<int> tUid, string templateName, string template, string status, string type, string action)
        {
            var tUidParameter = tUid.HasValue ?
                new ObjectParameter("TUid", tUid) :
                new ObjectParameter("TUid", typeof(int));
    
            var templateNameParameter = templateName != null ?
                new ObjectParameter("TemplateName", templateName) :
                new ObjectParameter("TemplateName", typeof(string));
    
            var templateParameter = template != null ?
                new ObjectParameter("Template", template) :
                new ObjectParameter("Template", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var typeParameter = type != null ?
                new ObjectParameter("Type", type) :
                new ObjectParameter("Type", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_Template_Result>("sp_Template", tUidParameter, templateNameParameter, templateParameter, statusParameter, typeParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_Ticket_Result> sp_Ticket(Nullable<int> tUid, string ticketNo, Nullable<int> sTUid, Nullable<int> pUid, string subject, string priority, string issueDetails, Nullable<System.DateTime> createdDate, string createdDatetime, Nullable<System.DateTime> resolvedDate, string resolvedDatetime, string ticketStatus, string attachment, string issueType, string status, string action)
        {
            var tUidParameter = tUid.HasValue ?
                new ObjectParameter("TUid", tUid) :
                new ObjectParameter("TUid", typeof(int));
    
            var ticketNoParameter = ticketNo != null ?
                new ObjectParameter("TicketNo", ticketNo) :
                new ObjectParameter("TicketNo", typeof(string));
    
            var sTUidParameter = sTUid.HasValue ?
                new ObjectParameter("STUid", sTUid) :
                new ObjectParameter("STUid", typeof(int));
    
            var pUidParameter = pUid.HasValue ?
                new ObjectParameter("PUid", pUid) :
                new ObjectParameter("PUid", typeof(int));
    
            var subjectParameter = subject != null ?
                new ObjectParameter("Subject", subject) :
                new ObjectParameter("Subject", typeof(string));
    
            var priorityParameter = priority != null ?
                new ObjectParameter("Priority", priority) :
                new ObjectParameter("Priority", typeof(string));
    
            var issueDetailsParameter = issueDetails != null ?
                new ObjectParameter("IssueDetails", issueDetails) :
                new ObjectParameter("IssueDetails", typeof(string));
    
            var createdDateParameter = createdDate.HasValue ?
                new ObjectParameter("CreatedDate", createdDate) :
                new ObjectParameter("CreatedDate", typeof(System.DateTime));
    
            var createdDatetimeParameter = createdDatetime != null ?
                new ObjectParameter("CreatedDatetime", createdDatetime) :
                new ObjectParameter("CreatedDatetime", typeof(string));
    
            var resolvedDateParameter = resolvedDate.HasValue ?
                new ObjectParameter("ResolvedDate", resolvedDate) :
                new ObjectParameter("ResolvedDate", typeof(System.DateTime));
    
            var resolvedDatetimeParameter = resolvedDatetime != null ?
                new ObjectParameter("ResolvedDatetime", resolvedDatetime) :
                new ObjectParameter("ResolvedDatetime", typeof(string));
    
            var ticketStatusParameter = ticketStatus != null ?
                new ObjectParameter("TicketStatus", ticketStatus) :
                new ObjectParameter("TicketStatus", typeof(string));
    
            var attachmentParameter = attachment != null ?
                new ObjectParameter("Attachment", attachment) :
                new ObjectParameter("Attachment", typeof(string));
    
            var issueTypeParameter = issueType != null ?
                new ObjectParameter("IssueType", issueType) :
                new ObjectParameter("IssueType", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_Ticket_Result>("sp_Ticket", tUidParameter, ticketNoParameter, sTUidParameter, pUidParameter, subjectParameter, priorityParameter, issueDetailsParameter, createdDateParameter, createdDatetimeParameter, resolvedDateParameter, resolvedDatetimeParameter, ticketStatusParameter, attachmentParameter, issueTypeParameter, statusParameter, actionParameter);
        }
    
        public virtual ObjectResult<sp_WorkExperience_Result> sp_WorkExperience(Nullable<int> wEUid, string experience, string status, string action)
        {
            var wEUidParameter = wEUid.HasValue ?
                new ObjectParameter("WEUid", wEUid) :
                new ObjectParameter("WEUid", typeof(int));
    
            var experienceParameter = experience != null ?
                new ObjectParameter("Experience", experience) :
                new ObjectParameter("Experience", typeof(string));
    
            var statusParameter = status != null ?
                new ObjectParameter("Status", status) :
                new ObjectParameter("Status", typeof(string));
    
            var actionParameter = action != null ?
                new ObjectParameter("Action", action) :
                new ObjectParameter("Action", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_WorkExperience_Result>("sp_WorkExperience", wEUidParameter, experienceParameter, statusParameter, actionParameter);
        }
    
        public virtual int GetCustomersPageWise(Nullable<int> pageIndex, Nullable<int> pageSize, ObjectParameter recordCount)
        {
            var pageIndexParameter = pageIndex.HasValue ?
                new ObjectParameter("PageIndex", pageIndex) :
                new ObjectParameter("PageIndex", typeof(int));
    
            var pageSizeParameter = pageSize.HasValue ?
                new ObjectParameter("PageSize", pageSize) :
                new ObjectParameter("PageSize", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetCustomersPageWise", pageIndexParameter, pageSizeParameter, recordCount);
        }
    }
}
