public DataTable SelectAllShop()
{
DataTable companyTable = new DataTable();
DataAccessManager dam = new DataAccessManager();
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectShop");
return companyTable;
}
public static DataTable Select(string UserId, string StartTicks, string EndTicks)
{
DataTable dt = null;
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = { {"@UserId", UserId},
{"@StartTicks", StartTicks},
{"@EndTicks", EndTicks}};
dt = dam.GetDataTable(CommandType.StoredProcedure, "SelectUserLog", paramArray);
return dt;
}
public DataTable SelectAllActiveCompanies()
{
DataTable companyTable = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectCompany");
}
catch (Exception ex)
{
throw ex;
}
return companyTable;
}
public static DataTable SelectRecentReceipt()
{
DataTable dt = null;
try
{
dt = new DataTable();
DataAccessManager dam = new DataAccessManager();
dt = dam.GetDataTable(CommandType.StoredProcedure, "RecentTopReceipt");
}
catch (Exception exe)
{
throw exe;
}
return dt;
}
public DataTable SelectAllItemTypes(string isActive)
{
DataTable companyTable = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{"@isActive",isActive}
};
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectItemType", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return companyTable;
}
public static DataTable SelectReceipt(string ReceiptId)
{
DataTable dt = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{ "@ReceiptId", ReceiptId }
};
dt = dam.GetDataTable(CommandType.StoredProcedure, "SelectReceipt", paramArray, "Receipt");
}
catch (Exception ex)
{
throw ex;
}
return dt;
}
public DataTable BuyerLedger(DateTime? StartDate, DateTime? EndDate, string Id)
{
DataTable dt = null;
try
{
string[,] paramArray = {
{"@StartDate", Common.FormateDateForDB(StartDate)},
{"@EndDate", Common.FormateDateForDB(EndDate)},
{"@Id", Id}
};
DataAccessManager dam = new DataAccessManager();
dt = dam.GetDataTable(CommandType.StoredProcedure, "Report_BuyerLedger", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return dt;
}
public static DataTable ViewExceptionLog(string startDate,string endDate,string Module)
{
DataTable datatableException = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] pararray = {
{"@StartDate",startDate},
{"@EndDate",endDate},
{"@Module",Module}
};
datatableException = dam.GetDataTable(CommandType.StoredProcedure, "SelectExceptionLog",pararray);
}
catch (Exception exe)
{
throw exe;
}
return datatableException;
}
public DataTable ProfitLoassReport(DateTime? StartDate, DateTime? EndDate, string reportLevel)
{
DataTable dt = null;
try
{
string[,] paramArray = {
{"@StartDate", Common.FormateDateForDB(StartDate)},
{"@EndDate", Common.FormateDateForDB(EndDate)},
{"@Level", reportLevel}
};
DataAccessManager dam = new DataAccessManager();
dt = dam.GetDataTable(CommandType.StoredProcedure, "Report_ProfitLost", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return dt;
}
private DataTable SalesPurchaseReport(string report, string StartDate, string EndDate, string Id)
{
DataTable dt = null;
try
{
string[,] paramArray = {
{"@Report",report},
{"@StartDate",StartDate},
{"@EndDate", EndDate},
{"@Id", Id}
};
DataAccessManager dam = new DataAccessManager();
dt = dam.GetDataTable(CommandType.StoredProcedure, "Report_SalesPurchase", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return dt;
}
public DataTable CurrentCashReport()
{
DataTable ds = null;
try
{
DataAccessManager dam = new DataAccessManager();
ds = dam.GetDataTable(CommandType.StoredProcedure, "Report_CurrentCashReport");
}
catch (Exception ex)
{
throw ex;
}
return ds;
}
public DataTable ProductTransactionSummaryReprot(string StartDate, string EndDate, string Id)
{
DataTable dt = null;
try
{
string[,] paramArray = {
{"@StartDate",StartDate},
{"@EndDate", EndDate},
{"@Id", Id}
};
DataAccessManager dam = new DataAccessManager();
dt = dam.GetDataTable(CommandType.StoredProcedure, "Report_ProductInOutSummaryReport", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return dt;
}
public DataTable SelectAllCompanies()
{
DataTable companyTable = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{"@OnlyActive", "0"}
};
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectCompany", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return companyTable;
}
/*
@ItemId int=null,
@ItemCode nvarchar(500) = null,
@ItemName nvarchar(500) = null,
@ItemType int = null,
@CompanyId
*/
public DataTable SelectItem(string ItemId, string ItemCode, string ItemName, string ItemType, string CompanyId, string isActive, int Operation)
{
DataTable companyTable = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {{"@ItemId", ItemId},
{"@ItemCode", ItemCode },
{"@ItemName", ItemName },
{"@ItemType", ItemType },
{"@CompanyId", CompanyId },
{"@isActive", isActive },
{"@Operation", Operation.ToString() }
};
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectItem", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return companyTable;
}
public DataTable SelectCompanyTransactions(string fromDate, string toDate, string Id)
{
DataTable companyTable = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{"@CustomerCompanyId",Id},
{"@FromTransactionDate",fromDate},
{"@ToTransactionDate", toDate },
{"@IsCustomer", "0"}
};
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectTransactions", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return companyTable;
}
//RECEIPT
public DataTable SelectReceiptsDateWise(string CustomerId, DateTime StartDate, DateTime EndDate, bool All)
{
DataTable dt = new DataTable();
try
{
StartDate = StartDate.Date.AddMilliseconds(-1);
EndDate = EndDate.Date.AddDays(1).AddMilliseconds(-1);
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{ "@CustomerId", All?null:CustomerId} ,
{ "@StartDate", All?null:Common.FormateDateForDB(StartDate)} ,
{ "@EndDate", All?null:Common.FormateDateForDB(EndDate)}
};
dt = dam.GetDataTable(CommandType.StoredProcedure, "SelectReceiptSummary", paramArray, "Receipt");
}
catch (Exception ex)
{
throw ex;
}
return dt;
}
public static bool IsCurrentDateValid()
{
bool result = false;
DataAccessManager dam = new DataAccessManager();
string[,] pararray = { { "@FromTransactionDate", FormateDateForDB(DateTime.Now.AddDays(1)) } };
DataTable dt = dam.GetDataTable(CommandType.StoredProcedure, "SelectTransactions", pararray);
if (dt != null)
result = dt.Rows.Count > 1;
return !result;
}
public DataTable SelectEmptyReceiptDetailTable()
{
DataTable table = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = { { "@TableName", "ReceiptDetail" } };
table = dam.GetDataTable(CommandType.StoredProcedure, "SelectEmptyTable", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return table;
}
public DataTable CompanyPurchaseReport(DateTime? StartDate, DateTime? EndDate, string Id, bool IsDetailed)
{
DataTable dt = null;
try
{
string[,] paramArray = {
{"@StartDate", Common.FormateDateForDB(StartDate)},
{"@EndDate", Common.FormateDateForDB(EndDate)},
{"@Id", Id},
{"@InDetail", IsDetailed?"1":"0"}
};
DataAccessManager dam = new DataAccessManager();
dt = dam.GetDataTable(CommandType.StoredProcedure, "Report_CompanyPurchaseReport", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return dt;
}
public static DataTable Login(string UserName, string Password)
{
DataTable dt = null;
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{"@UserName",UserName},
{"@Password",Password}
};
dt = dam.GetDataTable(System.Data.CommandType.StoredProcedure, "SystemUserLogin", paramArray);
return dt;
}
public static DataTable SelectUser(string Id, string UserName, string FullName)
{
DataTable dtUser = null;
try
{
dtUser = new DataTable();
DataAccessManager dam = new DataAccessManager();
string[,] pararray = {
{"@Id",Id},
{"@UserName",UserName},
{"@Name",FullName},
};
dtUser = dam.GetDataTable(CommandType.StoredProcedure, "SelectUser", pararray);
}
catch (Exception exe)
{
throw exe;
}
return dtUser;
}
public DataTable Stock()
{
DataTable stockTable = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
stockTable = dam.GetDataTable(CommandType.StoredProcedure, "Stock");
}
catch (Exception ex)
{
throw ex;
}
return stockTable;
}
public DataTable SelectCustomerByCode(string code)
{
DataTable companyTable = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{"@CustomerCode", code},
{"@OnlyActive", "0"}
};
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectCustomer", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return companyTable;
}
public static DataTable CheckCompanyItem(string companyId, string companyItem, string Packing)
{
try
{
//int result=0;
DataTable dt = null;
DataAccessManager dam = new DataAccessManager();
string[,] parayy = { {@"CompanyId",companyId}
,{@"CompanyItem",companyItem},
{@"Packing",Packing}};
dt = dam.GetDataTable(CommandType.StoredProcedure, "CheckCompanyItem", parayy);
return dt;
}
catch (Exception exe)
{
throw exe;
}
}
public DataTable SelectCompanyByCode(string code)
{
DataTable companyTable = new DataTable();
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{"@CompanyCode", code}
};
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectCompany", paramArray);
return companyTable;
}
public static DataTable ExecuteSelectQuery(string query)
{
DataTable dt = null;
try
{
DataAccessManager dam = new DataAccessManager();
dt = dam.GetDataTable(CommandType.Text, query);
}
catch (Exception ex)
{
throw;
}
return dt;
}
public DataTable SelectCompanyByName(string name)
{
DataTable companyTable = new DataTable();
try
{
DataAccessManager dam = new DataAccessManager();
string[,] paramArray = {
{"@CompanyName", name}
};
companyTable = dam.GetDataTable(CommandType.StoredProcedure, "SelectCompany", paramArray);
}
catch (Exception ex)
{
throw ex;
}
return companyTable;
}