public static DataTable getChartDataDetailByCustomers(DateTime?dateStart, DateTime?dateEnd, Guid?excludeCustomerID, DataTable dtCustomersID, DataTable dtGradeID,
DataTable dtProductStoreNameID, DataTable dtProductWidthID, DataTable dtLengthUnitID, DataTable dtColorID, bool isReportedOnly)
{
DataTable dataTable = new DataTable();
using (SqlCommand cmd = new SqlCommand("sale_charting_detailbycustomers", DBConnection.ActiveSqlConnection))
using (SqlDataAdapter adapter = new SqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@date_start", SqlDbType.DateTime).Value = Util.wrapNullable(dateStart);
cmd.Parameters.Add("@date_end", SqlDbType.DateTime).Value = Util.wrapNullable(dateEnd);
cmd.Parameters.Add("@exclude_customer_id", SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(excludeCustomerID);
cmd.Parameters.Add("@is_reported_only", SqlDbType.Bit).Value = isReportedOnly;
DBUtil.addListParameter(cmd, "@customer_id_list", dtCustomersID);
DBUtil.addListParameter(cmd, "@grade_id_list", dtGradeID);
DBUtil.addListParameter(cmd, "@product_storenameid_list", dtProductStoreNameID);
DBUtil.addListParameter(cmd, "@product_widthid_list", dtProductWidthID);
DBUtil.addListParameter(cmd, "@length_unitid_list", dtLengthUnitID);
DBUtil.addListParameter(cmd, "@colorid_list", dtColorID);
adapter.SelectCommand = cmd;
adapter.Fill(dataTable);
}
return(dataTable);
}
public static DataTable get(DateTime?dateStart, DateTime?dateEnd, Guid?inventoryID, Guid?customerID, Guid?Vendors_Id, Guid?saleID,
bool onlyHasReceivable, bool OnlyNoFakturPajak, bool onlyLossProfit, bool onlyReturnedToSupplier, bool onlyWithCommission, Guid?salesUserAccountID,
DataTable dtProductStoreNameID, DataTable dtColorID, bool onlyNotCompleted, bool onlyManualAdjustment, string inventoryCode,
Guid?FakturPajaks_Id, Guid?BrowsingForFakturPajak_Customers_Id, Guid?BrowsingForFakturPajak_Vendors_Id, Guid?VendorInvoices_Id,
bool showOnlyReminder_MasukanRetur, bool showOnlyReminder_Keluaran, Guid?Kontrabons_Id)
{
DataTable dataTable = new DataTable();
using (SqlCommand cmd = new SqlCommand("Sales_get", DBConnection.ActiveSqlConnection))
using (SqlDataAdapter adapter = new SqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@date_start", SqlDbType.DateTime).Value = (object)dateStart ?? DBNull.Value;
cmd.Parameters.Add("@date_end", SqlDbType.DateTime).Value = (object)dateEnd ?? DBNull.Value;
cmd.Parameters.Add("@inventory_item_id", SqlDbType.UniqueIdentifier).Value = (object)inventoryID ?? DBNull.Value;
cmd.Parameters.Add("@customer_id", SqlDbType.UniqueIdentifier).Value = (object)customerID ?? DBNull.Value;
cmd.Parameters.Add("@" + COL_DB_Vendors_Id, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(Vendors_Id);
cmd.Parameters.Add("@sale_id", SqlDbType.UniqueIdentifier).Value = (object)saleID ?? DBNull.Value;
cmd.Parameters.Add("@only_has_receivable", SqlDbType.Bit).Value = onlyHasReceivable;
cmd.Parameters.Add("@only_loss_profit", SqlDbType.Bit).Value = onlyLossProfit;
cmd.Parameters.Add("@include_special_user_only", SqlDbType.Bit).Value = GlobalData.UserAccount.role == Roles.Super;
cmd.Parameters.Add("@" + FILTER_OnlyNoFakturPajak, SqlDbType.Bit).Value = OnlyNoFakturPajak;
cmd.Parameters.Add("@" + FILTER_OnlyReturnedToSupplier, SqlDbType.Bit).Value = onlyReturnedToSupplier;
cmd.Parameters.Add("@" + FILTER_OnlyNotCompleted, SqlDbType.Bit).Value = onlyNotCompleted;
cmd.Parameters.Add("@" + FILTER_Inventory_Code, SqlDbType.VarChar).Value = Util.wrapNullable <string>(inventoryCode);
cmd.Parameters.Add("@" + FILTER_OnlyManualAdjustment, SqlDbType.Bit).Value = onlyManualAdjustment;
cmd.Parameters.Add("@" + COL_DB_FakturPajaks_Id, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(FakturPajaks_Id);
cmd.Parameters.Add("@" + COL_DB_Kontrabons_Id, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(Kontrabons_Id);
cmd.Parameters.Add("@" + FILTER_BrowsingForFakturPajak_Customers_Id, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(BrowsingForFakturPajak_Customers_Id);
cmd.Parameters.Add("@" + FILTER_BrowsingForFakturPajak_Vendors_Id, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(BrowsingForFakturPajak_Vendors_Id);
cmd.Parameters.Add("@" + FILTER_VendorInvoices_Id, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(VendorInvoices_Id);
cmd.Parameters.Add("@" + FILTER_ShowOnlyReminder_MasukanRetur, SqlDbType.Bit).Value = showOnlyReminder_MasukanRetur;
cmd.Parameters.Add("@" + FILTER_ShowOnlyReminder_Keluaran, SqlDbType.Bit).Value = showOnlyReminder_Keluaran;
if (onlyWithCommission)
{
if (salesUserAccountID == null)
{
cmd.Parameters.Add("@" + Sale.COL_DB_SaleCommission_Users_Id, SqlDbType.UniqueIdentifier).Value = GlobalData.UserAccount.id;
}
else
{
cmd.Parameters.Add("@" + Sale.COL_DB_SaleCommission_Users_Id, SqlDbType.UniqueIdentifier).Value = salesUserAccountID;
}
}
DBUtil.addListParameter(cmd, "@productstorename_id_list", dtProductStoreNameID);
DBUtil.addListParameter(cmd, "@color_id_list", dtColorID);
adapter.SelectCommand = cmd;
adapter.Fill(dataTable);
}
return(dataTable);
}
public static DataTable get(bool includeInactive, bool last3Months, int?code, DataTable dtProductStoreNameID, DataTable dtGradeID, DataTable dtProductWidthID, DataTable dtLengthUnitID,
DataTable dtColorID, Guid?vendorID, Guid?vendorInvoiceID, bool showNotBookedOnly)
{
//ERROR INVALID ARRAY SIZE
//SqlQueryResult result = DBConnection.query(
// true,
// DBConnection.ActiveSqlConnection,
// QueryTypes.FillByAdapter,
// "inventory_getall",
// DBConnection.createTableParameters(
// new SqlQueryTableParameterGuid("grade_id_list", dtGradeID),
// new SqlQueryTableParameterGuid("productstorename_id_list", dtProductStoreNameID),
// new SqlQueryTableParameterGuid("productwidth_id_list", dtProductWidthID),
// new SqlQueryTableParameterGuid("lengthunit_id_list", dtLengthUnitID),
// new SqlQueryTableParameterGuid("color_id_list", dtColorID)
// ),
// new SqlQueryParameter("include_inactive", SqlDbType.Bit, includeInactive),
// new SqlQueryParameter("last3Months", SqlDbType.Bit, last3Months),
// new SqlQueryParameter("code", SqlDbType.VarChar, code),
// new SqlQueryParameter("FILTER_ShowNotBookedOnly", SqlDbType.Bit, showNotBookedOnly),
// new SqlQueryParameter(COL_VENDORID, SqlDbType.UniqueIdentifier, Util.wrapNullable(vendorID)),
// new SqlQueryParameter(COL_DB_VENDORINVOICEID, SqlDbType.UniqueIdentifier, Util.wrapNullable(vendorInvoiceID))
// );
//return result.Datatable;
DataTable dataTable = new DataTable();
using (SqlCommand cmd = new SqlCommand("inventory_getall", DBConnection.ActiveSqlConnection))
using (SqlDataAdapter adapter = new SqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@include_inactive", SqlDbType.Bit).Value = includeInactive;
cmd.Parameters.Add("@last3Months", SqlDbType.Bit).Value = last3Months;
cmd.Parameters.Add("@code", SqlDbType.VarChar).Value = code;
cmd.Parameters.Add("@FILTER_ShowNotBookedOnly", SqlDbType.Bit).Value = showNotBookedOnly;
cmd.Parameters.Add("@" + COL_VENDORID, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(vendorID);
cmd.Parameters.Add("@" + COL_DB_VENDORINVOICEID, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(vendorInvoiceID);
DBUtil.addListParameter(cmd, "@grade_id_list", dtGradeID);
DBUtil.addListParameter(cmd, "@productstorename_id_list", dtProductStoreNameID);
DBUtil.addListParameter(cmd, "@productwidth_id_list", dtProductWidthID);
DBUtil.addListParameter(cmd, "@lengthunit_id_list", dtLengthUnitID);
DBUtil.addListParameter(cmd, "@color_id_list", dtColorID);
adapter.SelectCommand = cmd;
adapter.Fill(dataTable);
}
return(dataTable);
}
public static DataTable get(bool includeInactive, DataTable categoryEnumIDList, Guid?ID, string nameFilter, Guid?vendorID, Guid?retailLengthUnitID, Guid?bulkLengthUnitID, Guid?productWidthID)
{
DataTable datatable = new DataTable();
using (SqlCommand cmd = new SqlCommand("gordenitem_get", DBConnection.ActiveSqlConnection))
using (SqlDataAdapter adapter = new SqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@" + FILTER_INCLUDEINACTIVE, SqlDbType.Bit).Value = includeInactive;
DBUtil.addListParameter(cmd, "@" + FILTER_CATEGORYENUMIDLIST, categoryEnumIDList);
cmd.Parameters.Add("@" + COL_DB_ID, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(ID);
cmd.Parameters.Add("@" + COL_DB_NAME, SqlDbType.VarChar).Value = Util.wrapNullable(nameFilter);
cmd.Parameters.Add("@" + COL_DB_VENDORID, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(vendorID);
cmd.Parameters.Add("@" + COL_DB_RETAILLENGTHUNITID, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(retailLengthUnitID);
cmd.Parameters.Add("@" + COL_DB_BULKLENGTHUNITID, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(bulkLengthUnitID);
cmd.Parameters.Add("@" + COL_DB_PRODUCTWIDTHID, SqlDbType.UniqueIdentifier).Value = Util.wrapNullable(productWidthID);
adapter.SelectCommand = cmd;
adapter.Fill(datatable);
}
Tools.parseEnum <GordenItemCategories>(datatable, COL_CATEGORYNAME, COL_DB_CATEGORYENUMID);
return(datatable);
}
