public static DataTable Subscription_GetAllByFinancialYear(Entity.Subscription subscription) { using (DataManager oDm = new DataManager()) { if (subscription.MemberId == 0) { oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, DBNull.Value); } else { oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.MemberId); } oDm.Add("@FinancialYearId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.FinancialYearId); if (subscription.Status == 2) { oDm.Add("@Status", SqlDbType.Bit, DBNull.Value); } else { oDm.Add("@Status", SqlDbType.Bit, subscription.Status); } oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_Subscription_GetAllByFinancialYear")); } }
public static DataTable GetAll(int BranchId, int DesignationId, string FName) { using (DataManager oDm = new DataManager()) { if (BranchId > 0) { oDm.Add("@BranchId", SqlDbType.Int, BranchId); } else { oDm.Add("@BranchId", SqlDbType.Int, DBNull.Value); } if (DesignationId > 0) { oDm.Add("@DesignationId", SqlDbType.Int, DesignationId); } else { oDm.Add("@DesignationId", SqlDbType.Int, DBNull.Value); } if (FName.Trim().Length > 0) { oDm.Add("@FName", SqlDbType.VarChar, 50, FName); } else { oDm.Add("@FName", SqlDbType.VarChar, 50, DBNull.Value); } oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("EmployeeMaster_GetAll")); } }
public static DataTable FinancialYear_GetAll() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_FinancialYear_GetAll")); } }
public static DataTable GetAllBlockWithState() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_BlockWithState_GetAll")); } }
public static DataTable GetAllPortal() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_SMSTriggerPortal_GetAll")); } }
public static DataTable GetCurrentCircular() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_Circular_GetAll")); } }
public static DataTable GetBalance() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_SMSBalance")); } }
public static DataTable getMobileNumbers_Membership() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_GetMobileNumbers_Membership")); } }
public static DataTable GetDistrict() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_District_GetAll")); } }
public static DataTable GetNotificationMobNos() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_GetNotificationMobNos")); } }
public static DataTable GetCapacityAndLoadingByYear(string Year) { using (DataManager oDm = new DataManager()) { oDm.Add("@pYear", SqlDbType.VarChar, Year); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_CapacityAndLoading_GetByYear")); } }
public static DataTable getMembersForNotification() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_GetMembersForNotification")); } }
public static DataTable GetAllServiceEngg(int BranchId) { using (DataManager oDm = new DataManager()) { oDm.Add("@BranchId", SqlDbType.Int, BranchId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("EmployeeMaster_GetAllServiceEngg")); } }
public static DataTable GetRateByDate(string Year) { using (DataManager oDm = new DataManager()) { oDm.Add("@pDate", SqlDbType.DateTime, Convert.ToDateTime(Year)); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_PotatoRate_GetAllByDate")); } }
public static DataTable GetAll(string statename) { using (DataManager oDm = new DataManager()) { oDm.Add("@pStatename", SqlDbType.VarChar, 50, ParameterDirection.Input, statename); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_PotatoType_GetAllStateWise")); } }
public static string GetCurrentProvider() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; DataTable dt = oDm.ExecuteDataTable("usp_GetCurrentProvider"); return(dt.Rows[0][0].ToString().Trim()); } }
public static DataTable GetAll() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("AgentMaster_GetAll")); } }
public static int GetAppDownloadCount() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; DataTable DT = oDm.ExecuteDataTable("GetAppDownloadCount"); int Count = Convert.ToInt32(DT.Rows[0]["Count"]); return(Count); } }
public static DataTable GetUnloadingByMonthAndYear(int Month, string Year) { using (DataManager oDm = new DataManager()) { oDm.Add("@pYear", SqlDbType.VarChar, Year); oDm.Add("@pMonth", SqlDbType.Int, Month); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_Unloading_GetByMonthAndYear")); } }
public static DataTable Subscription_GetBySubscriptionId(Int64 subscriptionId) { using (DataManager oDm = new DataManager()) { oDm.Add("@SubscriptionId", SqlDbType.BigInt, ParameterDirection.Input, subscriptionId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_Subscription_GetBySubscriptionId")); } }
public static DataTable GetUpRateByDate(string date, int potatoTypeId) { using (DataManager oDm = new DataManager()) { oDm.Add("@pDate", SqlDbType.DateTime, Convert.ToDateTime(date)); oDm.Add("@pPotatoTypeId", SqlDbType.Int, potatoTypeId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_UpPotatoRate_GetAllByDate")); } }
public static DataTable GetMemberPaidAmount_byFinancialYear(int memberId, int financialYearId) { using (DataManager oDm = new DataManager()) { oDm.Add("@MemberId", SqlDbType.Int, ParameterDirection.Input, memberId); oDm.Add("@FinancialYearId", SqlDbType.Int, ParameterDirection.Input, financialYearId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_GetMemberPaidAmount_byFinancialYear")); } }
public static DataTable SubscriptionDetails_GetByTransactionId(int TransactionId) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@pTransactionId", SqlDbType.Int, TransactionId); DataTable Dt = oDm.ExecuteDataTable("SubscriptionDetails_GetByTransactionId"); return(Dt); } }
public static bool IsMessageSentToday() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; DataTable DT = oDm.ExecuteDataTable("usp_SMSTrigger_MessageToday"); if (DT.Rows.Count > 0) { return(true); } else { return(false); } } }
public static DataTable EngineerPerformance(int branchId, int engineerId, DateTime startDate, DateTime endDate) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; if (branchId == 0) { oDm.Add("@pBranchId", SqlDbType.Int, DBNull.Value); } else { oDm.Add("@pBranchId", SqlDbType.Int, branchId); } if (engineerId == 0) { oDm.Add("@pEngineerId", SqlDbType.Int, DBNull.Value); } else { oDm.Add("@pEngineerId", SqlDbType.Int, engineerId); } if (startDate == DateTime.MinValue) { oDm.Add("@StartDate", SqlDbType.DateTime, DBNull.Value); } else { oDm.Add("@StartDate", SqlDbType.DateTime, startDate); } if (endDate == DateTime.MinValue) { oDm.Add("@pEndDate", SqlDbType.DateTime, DBNull.Value); } else { oDm.Add("@pEndDate", SqlDbType.DateTime, endDate); } return(oDm.ExecuteDataTable("usp_EngineerPerofrmanceReport")); } }
public static DataTable GetAll(string FormNo, int DistrictId, string BlockName, string MemberName, string MobileNo, string ExpiryDate, int SearchType, string SMSSubscriberAmt) { using (DataManager oDm = new DataManager()) { if (FormNo.Trim().Length == 0) { oDm.Add("@pFormNo", SqlDbType.VarChar, 20, ParameterDirection.Input, DBNull.Value); } else { oDm.Add("@pFormNo", SqlDbType.VarChar, 20, ParameterDirection.Input, FormNo); } if (DistrictId == 0) { oDm.Add("@pDistrictId", SqlDbType.Int, ParameterDirection.Input, DBNull.Value); } else { oDm.Add("@pDistrictId", SqlDbType.Int, ParameterDirection.Input, DistrictId); } if (BlockName.Trim().Length > 0) { oDm.Add("@pBlockName", SqlDbType.VarChar, 250, BlockName); } else { oDm.Add("@pBlockName", SqlDbType.VarChar, 250, DBNull.Value); } if (MemberName.Trim().Length == 0) { oDm.Add("@pMemberName", SqlDbType.VarChar, 50, ParameterDirection.Input, DBNull.Value); } else { oDm.Add("@pMemberName", SqlDbType.VarChar, 50, ParameterDirection.Input, MemberName); } if (MobileNo.Trim().Length == 0) { oDm.Add("@pMobileNo", SqlDbType.VarChar, 10, DBNull.Value); } else { oDm.Add("@pMobileNo", SqlDbType.VarChar, 10, MobileNo); } if (ExpiryDate.Trim().Length == 0) { oDm.Add("@pExpireDate", SqlDbType.DateTime, DBNull.Value); } else { oDm.Add("@pExpireDate", SqlDbType.DateTime, Convert.ToDateTime(ExpiryDate)); } oDm.Add("@pSearchType", SqlDbType.Int, SearchType); if (SMSSubscriberAmt.Trim().Length == 0) { oDm.Add("@pSMSSubscriberAmt", SqlDbType.Decimal, DBNull.Value); } else { oDm.Add("@pSMSSubscriberAmt", SqlDbType.Decimal, Convert.ToDecimal(SMSSubscriberAmt)); } oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_Merchant_GetAll")); } }
public static DataTable Subscription_GetAll(Entity.Subscription subscription) { using (DataManager oDm = new DataManager()) { if (subscription.MemberId == 0) { oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, DBNull.Value); } else { oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.MemberId); } if (subscription.FinancialYearId == 0) { oDm.Add("@FinancialYearId_FK", SqlDbType.Int, ParameterDirection.Input, DBNull.Value); } else { oDm.Add("@FinancialYearId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.FinancialYearId); } if (subscription.EntryDate == DateTime.MinValue) { oDm.Add("@EntryDateFrom", SqlDbType.DateTime, ParameterDirection.Input, DBNull.Value); } else { oDm.Add("@EntryDateFrom", SqlDbType.DateTime, ParameterDirection.Input, subscription.EntryDate); } if (subscription.EntryDateTo == DateTime.MinValue) { oDm.Add("@EntryDateTo", SqlDbType.DateTime, ParameterDirection.Input, DBNull.Value); } else { oDm.Add("@EntryDateTo", SqlDbType.DateTime, ParameterDirection.Input, subscription.EntryDateTo); } if (subscription.Status == 2) { oDm.Add("@Status", SqlDbType.Bit, DBNull.Value); } else { oDm.Add("@Status", SqlDbType.Bit, subscription.Status); } if (subscription.MobileNo.Trim().Length == 0) { oDm.Add("@MobileNo", SqlDbType.VarChar, 10, DBNull.Value); } else { oDm.Add("@MobileNo", SqlDbType.VarChar, 10, subscription.MobileNo); } if (subscription.BlockName == "--SELECT--") { oDm.Add("@BlockName", SqlDbType.VarChar, 250, DBNull.Value); } else { oDm.Add("@BlockName", SqlDbType.VarChar, 250, subscription.BlockName); } if (subscription.Amount == 0) { oDm.Add("@Amount", SqlDbType.Decimal, DBNull.Value); } else { oDm.Add("@Amount", SqlDbType.Decimal, subscription.Amount); } oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_Subscription_GetAll")); } }