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