public ProductType IUD(ProductType oProductType, EnumDBOperation eDBAction, int nUserID)
{
Connection.Open();
Command.CommandText = ProductTypeDA.IUD(oProductType, eDBAction, nUserID);
SqlDataReader reader = Command.ExecuteReader();
ProductType _oProductType = new ProductType();
if (reader.HasRows)
{
_oProductType = MakeObject(reader);
}
reader.Close();
Connection.Close();
return(_oProductType);
}
public ProductCategory IUD(ProductCategory oProductCategory, EnumDBOperation eDBAction, int userid)
{
Connection.Open();
Command.CommandText = ProductCategoryDA.IUD(oProductCategory, eDBAction, userid);
SqlDataReader reader = Command.ExecuteReader();
ProductCategory _oProductCategory = new ProductCategory();
if (reader.HasRows)
{
_oProductCategory = MakeObject(reader);
}
reader.Close();
Connection.Close();
return(_oProductCategory);
}
public static string IUD(Product oProduct, EnumDBOperation oDBOperation, int nUserID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_Product",
oProduct.ProductID, oProduct.ProductName, oProduct.ProductCode, oProduct.ProductTypeID, oProduct.ProductCategoryID, oProduct.UnitPrice, (int)oDBOperation, nUserID));
}
public static string IUD(Store oStore, EnumDBOperation oDBOperation, int nStoreID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_Store",
oStore.StoreID, oStore.StoreName, oStore.StoreShortName, oStore.Capacity, (int)oDBOperation, nStoreID));
}
public static string IUD(StoreProductHistory oStoreProductHistoryHistory, EnumDBOperation oDBOperation, int nUserID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_StoreProduct"));
}
public static string IUD(BillDetail oBillDetail, EnumDBOperation eDBAction, int userID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_BillDetail", oBillDetail.BillDetailID, oBillDetail.BillID,
oBillDetail.ProductName, oBillDetail.Price, oBillDetail.Quantity, (int)eDBAction, userID));
}
public static string IUD(Contractor oContractor, EnumDBOperation oDBOperation, int nUserID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_Contractor",
oContractor.ContractorID, oContractor.ContractorName, oContractor.CompanyName, (int)oContractor.ContractorType, oContractor.Email,
oContractor.Mobile, oContractor.Code, oContractor.Address, (int)oDBOperation, nUserID));
}
public static string IUD(ProductType oProductType, EnumDBOperation eDBAction, int userID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_ProductType", oProductType.ProductTypeID, oProductType.ProductTypeName, oProductType.ProductTypeCode, (int)eDBAction, userID));
}
public static string IUD(StoreProduct oStoreProduct, EnumDBOperation oDBOperation, int nUserID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_StoreProduct",
oStoreProduct.StoreProductID, oStoreProduct.StoreID, oStoreProduct.ProductID, oStoreProduct.ContractorID, oStoreProduct.ProductQty, oStoreProduct.ProductNewQty,
oStoreProduct.Remarks, oStoreProduct.CustomerName, oStoreProduct.Rate, (int)oDBOperation, nUserID));
}
public static string IUD(ProductCategory oProductCategory, EnumDBOperation eDBAction, int userID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_ProductCategory", oProductCategory.ProductCategoryID, oProductCategory.CategoryName, oProductCategory.CategoryCode, oProductCategory.ProductTypeID, oProductCategory.Activity, oProductCategory.Note, (int)eDBAction, userID));
}
public static string IUD(Bill oBill, EnumDBOperation eDBAction, int userID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_Bill", oBill.BillID, oBill.BillNo, (int)oBill.BillStatus, oBill.BillDate, oBill.CustomerName, oBill.CustomerMobile, oBill.CustomerAddress, oBill.StoreID,
oBill.PaidTotal, oBill.DiscountAmount, oBill.DiscountPercent, oBill.GrandTotal, oBill.DueAmount, oBill.Remarks, oBill.BillID_Ref, (int)eDBAction, userID));
}
public static string IUD(User oUser, EnumDBOperation oDBOperation, int nUserID)
{
return(GlobalHelpers.ExcecuteQurey("EXEC SP_IUD_User",
oUser.UserID, oUser.UserName, oUser.UserShortName, oUser.Password, (int)oUser.UserType, oUser.Email, oUser.Mobile,
oUser.Code, oUser.Validity, oUser.Activity, (int)oDBOperation, nUserID));
}
