public Suppliers GetSupplierById(int supplierId)
{
List <Suppliers> supplierList = new List <Suppliers>();
// List<IBSparameter> parameters = new List<IBSparameter>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter SupplierIdParameter = new IBSparameter();
SupplierIdParameter.ParameterName = "@SupplierId";
SupplierIdParameter.DataType = DbType.Int32;
SupplierIdParameter.Value = supplierId;
SupplierIdParameter.Direction = ParameterDirection.Input;
parameters.Add(SupplierIdParameter);
}
DataSet dsSupplier = null;
dsSupplier = GetDataSet("ERP_Get_SupplierById", parameters);
var SupplierCollection = from Suppliers in dsSupplier.Tables[0].AsEnumerable()
select new Suppliers
{
SupplierId = Suppliers.Field <int>("SupplierId"),
SupplierCode = Suppliers.Field <String>("SupplierCode"),
SupplierName = Suppliers.Field <String>("SupplierName"),
Address = Suppliers.Field <String>("Address"),
City = Suppliers.Field <String>("City"),
ContactEmail = Suppliers.Field <String>("ContactEmail"),
ContactName = Suppliers.Field <String>("ContactName"),
ContactTitle = Suppliers.Field <String>("ContactTitle"),
Country = Suppliers.Field <String>("Country"),
Phone1 = Suppliers.Field <String>("Phone1"),
Phone2 = Suppliers.Field <String>("Phone2"),
PostalCode = Suppliers.Field <String>("PostalCode"),
Website = Suppliers.Field <String>("Website"),
Fax = Suppliers.Field <String>("Fax")
};
supplierList = SupplierCollection.ToList <Suppliers>();
}
catch (Exception ex)
{
Logger.Error("Supplier.GetSupplierById(" + LoggedInUser + "," + CompanyCode + "," + supplierId + ")", ex);
}
return(supplierList[0]);
}
public ReturnResult DeleteSupplier(int supplierid)
{
//Category objCategory = new Category();
ReturnResult returnResult = new ReturnResult();
try
{
//int b=1, a=0;
//int c = b / a;
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter CatergoryIdParameter = new IBSparameter();
CatergoryIdParameter.ParameterName = "@SupplierId";
CatergoryIdParameter.DataType = DbType.Int32;
CatergoryIdParameter.Value = supplierid;
CatergoryIdParameter.Direction = ParameterDirection.Input;
parameters.Add(CatergoryIdParameter);
IBSparameter ReturnParameter = new IBSparameter();
ReturnParameter.ParameterName = "@ReturnValue";
ReturnParameter.DataType = DbType.Int32;
ReturnParameter.Value = "";
ReturnParameter.Direction = ParameterDirection.Output;
parameters.Add(ReturnParameter);
}
return(ExecuteSqlNonQuery("ERP_Delete_Supplier", parameters));
//if (count > 0)
//{
// returnResult.ID = count;
// returnResult.IsSuccess = true;
// returnResult.Message = "Category removed successfully.";
//}
////DbCommand command = database.GetStoredProcCommand("ERP_Delete_Category"); // SP name
////database.AddInParameter(command, "@CategoryId", DbType.Int32, categoryid);
////database.AddInParameter(command, "@LoginUser", DbType.String, loginUser);
////database.ExecuteNonQuery(command);
}
catch (Exception ex)
{
Logger.Error("SupplierDAL.DeleteSupplier(" + LoggedInUser + "," + CompanyCode + "," + supplierid + ")", ex);
}
return(returnResult);
}
public Stores GetStoreById(int StoreID)
{
List <Stores> storeList = new List <Stores>();
// List<IBSparameter> parameters = new List<IBSparameter>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter StoreIdParameter = new IBSparameter();
StoreIdParameter.ParameterName = "@StoreID";
StoreIdParameter.DataType = DbType.String;
StoreIdParameter.Value = StoreID;
StoreIdParameter.Direction = ParameterDirection.Input;
parameters.Add(StoreIdParameter);
}
DataSet dsStore = null;
dsStore = GetDataSet("ERP_Get_StoreByID", parameters);
var StoreCollection = from Stores in dsStore.Tables[0].AsEnumerable()
select new Stores
{
StoreId = Stores.Field <int>("StoreId"),
StoreName = Stores.Field <String>("StoreName"),
Address = Stores.Field <String>("Address"),
City = Stores.Field <String>("City"),
Email = Stores.Field <String>("Email"),
};
storeList = StoreCollection.ToList <Stores>();
}
catch (Exception ex)
{
//Logger.Error("CategoriesDAL.GetCategoryById(" + LoggedInUser + "," + CompanyCode + "," + categoryId + ")", ex);
}
return(storeList[0]);
}
public CompanyMaster GetCompanyById(int CompanyID)
{
List <CompanyMaster> companyList = new List <CompanyMaster>();
// List<IBSparameter> parameters = new List<IBSparameter>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter CompanyIdParameter = new IBSparameter();
CompanyIdParameter.ParameterName = "@CompanyID";
CompanyIdParameter.DataType = DbType.String;
CompanyIdParameter.Value = CompanyID;
CompanyIdParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyIdParameter);
}
DataSet dsCategory = null;
dsCategory = GetDataSet("ERP_Get_CompanyByID", parameters);
var CompanyCollection = from CompanyMaster in dsCategory.Tables[0].AsEnumerable()
select new CompanyMaster
{
CompanyId = CompanyMaster.Field <int>("CompanyID"),
CompanyCode = CompanyMaster.Field <String>("CompanyCode"),
CompanyName = CompanyMaster.Field <String>("CompanyName"),
RegistrationNo = CompanyMaster.Field <String>("RegistrationNo"),
City = CompanyMaster.Field <String>("City"),
Address = CompanyMaster.Field <String>("Address"),
};
companyList = CompanyCollection.ToList <CompanyMaster>();
}
catch (Exception ex)
{
//Logger.Error("CategoriesDAL.GetCategoryById(" + LoggedInUser + "," + CompanyCode + "," + categoryId + ")", ex);
}
return(companyList[0]);
}
public EmployeeMaster GetEmployeeById(int employeeID)
{
List <EmployeeMaster> EmployeeList = new List <EmployeeMaster>();
// List<IBSparameter> parameters = new List<IBSparameter>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter EmployeeIDParameter = new IBSparameter();
EmployeeIDParameter.ParameterName = "@EmployeeID";
EmployeeIDParameter.DataType = DbType.String;
EmployeeIDParameter.Value = employeeID;
EmployeeIDParameter.Direction = ParameterDirection.Input;
parameters.Add(EmployeeIDParameter);
}
DataSet dsEmployee = null;
dsEmployee = GetDataSet("ERP_Get_CompanyByID", parameters);
var CompanyCollection = from EmployeeMaster in dsEmployee.Tables[0].AsEnumerable()
select new EmployeeMaster
{
EmployeeId = EmployeeMaster.Field <int>("EmployeeID"),
LastName = EmployeeMaster.Field <String>("LastName"),
FirstName = EmployeeMaster.Field <String>("FirstName"),
Region = EmployeeMaster.Field <String>("Region"),
City = EmployeeMaster.Field <String>("City"),
Address = EmployeeMaster.Field <String>("Address"),
PostalCode = EmployeeMaster.Field <String>("PostalCode"),
};
EmployeeList = CompanyCollection.ToList <EmployeeMaster>();
}
catch (Exception ex)
{
//Logger.Error("CategoriesDAL.GetCategoryById(" + LoggedInUser + "," + CompanyCode + "," + categoryId + ")", ex);
}
return(EmployeeList[0]);
}
public List <Suppliers> GetSuppliersList()
{
List <Suppliers> objSuppliersList = new List <Suppliers>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
}
DataSet dsSuppliers = null;
dsSuppliers = GetDataSet("ERP_Get_SuppliersList", parameters);
var supplierCollection = from Suppliers in dsSuppliers.Tables[0].AsEnumerable()
select new Suppliers
{
SupplierId = Suppliers.Field <int>("SupplierId"),
SupplierCode = Suppliers.Field <String>("SupplierCode"),
SupplierName = Suppliers.Field <String>("SupplierName"),
Address = Suppliers.Field <String>("Address"),
City = Suppliers.Field <String>("City"),
ContactEmail = Suppliers.Field <String>("ContactEmail"),
ContactName = Suppliers.Field <String>("ContactName"),
ContactTitle = Suppliers.Field <String>("ContactTitle"),
Country = Suppliers.Field <String>("Country"),
Phone1 = Suppliers.Field <String>("Phone1"),
Phone2 = Suppliers.Field <String>("Phone2"),
PostalCode = Suppliers.Field <String>("PostalCode"),
Website = Suppliers.Field <String>("Website"),
Fax = Suppliers.Field <String>("Fax")
//LockStatus = Suppliers.Field<String>("LockStatus"),
};
objSuppliersList = supplierCollection.ToList <Suppliers>();
}
catch (Exception ex)
{
Logger.Error("SuppliersDAL.GetSuppliersList(" + LoggedInUser + "," + CompanyCode + ")", ex);
}
return(objSuppliersList);
}
public List <Category> GetCategories()
{
List <Category> objCategories = new List <Category>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
}
else if (DBProvider == ProviderName.MySqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "p_UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
}
DataSet dsCategory = null;
dsCategory = GetDataSet("ERP_Get_Categories", parameters);
var menuCollection = from Category in dsCategory.Tables[0].AsEnumerable()
select new Category
{
categoryid = Category.Field <int>("categoryid"),
CategoryCode = Category.Field <String>("CategoryCode"),
CategoryName = Category.Field <String>("CategoryName"),
Description = Category.Field <String>("Description"),
};
objCategories = menuCollection.ToList <Category>();
}
catch (Exception ex)
{
Logger.Error("CategoriesDAL.objCategories(" + LoggedInUser + "," + CompanyCode + ")", ex);
}
return(objCategories);
}
public List <ProductMaster> GetProductList()
{
List <ProductMaster> objProductList = new List <ProductMaster>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
}
DataSet dsProduct = null;
dsProduct = GetDataSet("ERP_Get_ProductList", parameters);
var ProductCollection = from ProductMaster in dsProduct.Tables[0].AsEnumerable()
select new ProductMaster
{
ProductId = ProductMaster.Field <int>("ProductId"),
ProductCode = ProductMaster.Field <String>("ProductCode"),
ProductName = ProductMaster.Field <String>("ProductName"),
BarCode = ProductMaster.Field <String>("BarCode"),
SupplierName = ProductMaster.Field <String>("SupplierName"),
CategoryName = ProductMaster.Field <String>("CategoryName"),
CompanyPrice = ProductMaster.Field <decimal>("CompanyPrice"),
RePOorderLevel = ProductMaster.Field <int>("RePOorderLevel"),
RePOorderQuantity = ProductMaster.Field <int>("RePOorderQuantity"),
UOM = ProductMaster.Field <String>("UOM"),
ReSOorderLevel = ProductMaster.Field <int>("ReSOorderLevel"),
ReSOorderQuantity = ProductMaster.Field <int>("ReSOorderQuantity")
};
objProductList = ProductCollection.ToList <ProductMaster>();
}
catch (Exception ex)
{
Logger.Error("ProductDAL.GetProductList(" + LoggedInUser + "," + CompanyCode + ")", ex);
}
return(objProductList);
}
public List <EmployeeMaster> BindEMPCode_Autocomplete(EmployeeMaster objEmployee)
{
List <EmployeeMaster> EmployeeList = new List <EmployeeMaster>();
// List<IBSparameter> parameters = new List<IBSparameter>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter EmployeeIDParameter = new IBSparameter();
EmployeeIDParameter.ParameterName = "@EMPCode";
EmployeeIDParameter.DataType = DbType.String;
EmployeeIDParameter.Value = objEmployee.EmpCode;
EmployeeIDParameter.Direction = ParameterDirection.Input;
parameters.Add(EmployeeIDParameter);
}
DataSet dsEmployee = null;
dsEmployee = GetDataSet("ERP_AutoComplete_BindEMPCode", parameters);
var CompanyCollection = from EmployeeMaster in dsEmployee.Tables[0].AsEnumerable()
select new EmployeeMaster
{
EmpCode = EmployeeMaster.Field <string>("EmpCode"),
};
EmployeeList = CompanyCollection.ToList <EmployeeMaster>();
}
catch (Exception ex)
{
//Logger.Error("CategoriesDAL.GetCategoryById(" + LoggedInUser + "," + CompanyCode + "," + categoryId + ")", ex);
}
return(EmployeeList);
}
public ReturnResult DeleteEmployee(int employeeID)
{
ReturnResult returnResult = new ReturnResult();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter CompanyIdParameter = new IBSparameter();
CompanyIdParameter.ParameterName = "@EmployeeID";
CompanyIdParameter.DataType = DbType.String;
CompanyIdParameter.Value = employeeID;
CompanyIdParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyIdParameter);
IBSparameter Flag = new IBSparameter();
Flag.ParameterName = "@Flag";
Flag.DataType = DbType.String;
Flag.Value = "D";
Flag.Direction = ParameterDirection.Input;
parameters.Add(Flag);
}
return(ExecuteSqlNonQuery("ERP_Save_Company", parameters));
}
catch (Exception ex)
{
// Logger.Error("CategoriesDAL.DeleteCategory(" + LoggedInUser + "," + CompanyCode + "," + categoryid + ")", ex);
}
return(returnResult);
}
public List <Lookup> GetLookupList(string lookupType)
{
List <Lookup> objLookupList = new List <Lookup>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@LookupType";
Userparameter.DataType = DbType.String;
Userparameter.Value = lookupType;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
}
else if (DBProvider == ProviderName.MySqlClient)
{
}
DataSet dsLookup = null;
dsLookup = GetDataSet("ERP_Get_LookUpData", parameters);
var menuCollection = from Lookup in dsLookup.Tables[0].AsEnumerable()
select new Lookup
{
//LookupId = Lookup.Field<int>("Lookupid"),
Code = Lookup.Field <String>("Code"),
Text = Lookup.Field <String>("Text"),
};
objLookupList = menuCollection.ToList <Lookup>();
}
catch (Exception ex)
{
Logger.Error("CommonDAL.GetLookupList(" + LoggedInUser + "," + CompanyCode + ")", ex);
}
return(objLookupList);
}
public List <Stores> GetStores()
{
List <Stores> objStores = new List <Stores>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
}
DataSet dsStores = null;
dsStores = GetDataSet("ERP_Get_Stores", parameters);
var MenuCollection = from Stores in dsStores.Tables[0].AsEnumerable()
select new Stores
{
StoreId = Stores.Field <int>("StoreID"),
StoreName = Stores.Field <String>("StoreName"),
Address = Stores.Field <String>("Address"),
City = Stores.Field <String>("City"),
Phone1 = Stores.Field <String>("Phone1"),
Email = Stores.Field <String>("Email"),
};
objStores = MenuCollection.ToList <Stores>();
}
catch (Exception ex)
{
//Logger.Error("CategoriesDAL.objCategories(" + LoggedInUser + "," + CompanyCode + ")", ex);
}
return(objStores);
}
public List <CompanyMaster> GetCompanies()
{
List <CompanyMaster> objCompanies = new List <CompanyMaster>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
}
DataSet dsCategory = null;
dsCategory = GetDataSet("ERP_Get_Companies", parameters);
var MenuCollection = from CompanyMaster in dsCategory.Tables[0].AsEnumerable()
select new CompanyMaster
{
CompanyId = CompanyMaster.Field <int>("CompanyID"),
CompanyCode = CompanyMaster.Field <String>("CompanyCode"),
CompanyName = CompanyMaster.Field <String>("CompanyName"),
RegistrationNo = CompanyMaster.Field <String>("RegistrationNo"),
};
objCompanies = MenuCollection.ToList <CompanyMaster>();
}
catch (Exception ex)
{
Logger.Error("CategoriesDAL.objCategories(" + LoggedInUser + "," + CompanyCode + ")", ex);
}
return(objCompanies);
}
public ReturnResult SaveEmployee(EmployeeMaster employee)
{
EmployeeMaster objEmployee = new EmployeeMaster();
ReturnResult returnResult = new ReturnResult();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter EmployeeIDParameter = new IBSparameter();
EmployeeIDParameter.ParameterName = "@EmployeeID";
EmployeeIDParameter.DataType = DbType.String;
EmployeeIDParameter.Value = employee.EmployeeId;
EmployeeIDParameter.Direction = ParameterDirection.Input;
parameters.Add(EmployeeIDParameter);
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter EmpCodeParameter = new IBSparameter();
EmpCodeParameter.ParameterName = "@EmpCode";
EmpCodeParameter.DataType = DbType.String;
EmpCodeParameter.Value = employee.EmpCode;
EmpCodeParameter.Direction = ParameterDirection.Input;
parameters.Add(EmpCodeParameter);
IBSparameter FirstNameParameter = new IBSparameter();
FirstNameParameter.ParameterName = "@FirstName";
FirstNameParameter.DataType = DbType.String;
FirstNameParameter.Value = employee.FirstName;
FirstNameParameter.Direction = ParameterDirection.Input;
parameters.Add(FirstNameParameter);
IBSparameter LastNameParameter = new IBSparameter();
LastNameParameter.ParameterName = "@LastName";
LastNameParameter.DataType = DbType.String;
LastNameParameter.Value = employee.LastName;
LastNameParameter.Direction = ParameterDirection.Input;
parameters.Add(LastNameParameter);
IBSparameter CompanyAddressParameter = new IBSparameter();
CompanyAddressParameter.ParameterName = "@Address";
CompanyAddressParameter.DataType = DbType.String;
CompanyAddressParameter.Value = employee.Address;
CompanyAddressParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyAddressParameter);
IBSparameter EmployeeCityParameter = new IBSparameter();
EmployeeCityParameter.ParameterName = "@City";
EmployeeCityParameter.DataType = DbType.String;
EmployeeCityParameter.Value = employee.City;
EmployeeCityParameter.Direction = ParameterDirection.Input;
parameters.Add(EmployeeCityParameter);
IBSparameter TitleParameter = new IBSparameter();
TitleParameter.ParameterName = "@Title";
TitleParameter.DataType = DbType.String;
TitleParameter.Value = employee.City;
TitleParameter.Direction = ParameterDirection.Input;
parameters.Add(TitleParameter);
IBSparameter RegionParameter = new IBSparameter();
RegionParameter.ParameterName = "@Region";
RegionParameter.DataType = DbType.String;
RegionParameter.Value = employee.Region;
RegionParameter.Direction = ParameterDirection.Input;
parameters.Add(RegionParameter);
IBSparameter PostalCode_Parameter = new IBSparameter();
PostalCode_Parameter.ParameterName = "@PostalCode";
PostalCode_Parameter.DataType = DbType.String;
PostalCode_Parameter.Value = employee.PostalCode;
PostalCode_Parameter.Direction = ParameterDirection.Input;
parameters.Add(PostalCode_Parameter);
IBSparameter Country_Parameter = new IBSparameter();
Country_Parameter.ParameterName = "@Country";
Country_Parameter.DataType = DbType.String;
Country_Parameter.Value = employee.PostalCode;
Country_Parameter.Direction = ParameterDirection.Input;
parameters.Add(Country_Parameter);
//IBSparameter PostalCodeParameter = new IBSparameter();
//PostalCodeParameter.ParameterName = "@PostalCode";
//PostalCodeParameter.DataType = DbType.String;
//PostalCodeParameter.Value = employee.PostalCode;
//PostalCodeParameter.Direction = ParameterDirection.Input;
//PostalCodeParameter.Add(PostalCodeParameter);
//IBSparameter CountryParameter = new IBSparameter();
//CountryParameter.ParameterName = "@Country";
//CountryParameter.DataType = DbType.String;
//CountryParameter.Value = employee.Country;
//CountryParameter.Direction = ParameterDirection.Input;
//CountryParameter.Add(CountryParameter);
IBSparameter Flag = new IBSparameter();
Flag.ParameterName = "@Flag";
Flag.DataType = DbType.String;
Flag.Value = "I";
Flag.Direction = ParameterDirection.Input;
parameters.Add(Flag);
//IBSparameter returnParameter = new IBSparameter();
//returnParameter.ParameterName = "@ReturnValue";
//returnParameter.DataType = DbType.Int32;
//returnParameter.Value = "";
//returnParameter.Direction = ParameterDirection.Output;
//parameters.Add(returnParameter);
}
return(ExecuteSqlNonQuery("ERP_Save_Employee", parameters));
}
catch (Exception ex)
{
//Logger.Error("CompanyDAL.SaveCompany(" + LoggedInUser + "," + CompanyCode + "," + company.CompanyCode + ")", ex);
}
return(returnResult);
}
public bool isUserHasPermission(string permissionName)
{
bool returnValue = false;
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "@UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
IBSparameter userRoleParameter = new IBSparameter();
userRoleParameter.ParameterName = "@RoleId";
userRoleParameter.DataType = DbType.String;
userRoleParameter.Value = UserRoleId;
userRoleParameter.Direction = ParameterDirection.Input;
parameters.Add(userRoleParameter);
IBSparameter permissionNameParameter = new IBSparameter();
permissionNameParameter.ParameterName = "@PermissionName";
permissionNameParameter.DataType = DbType.String;
permissionNameParameter.Value = permissionName;
permissionNameParameter.Direction = ParameterDirection.Input;
parameters.Add(permissionNameParameter);
}
else if (DBProvider == ProviderName.MySqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "p_UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
IBSparameter userRoleParameter = new IBSparameter();
userRoleParameter.ParameterName = "p_RoleId";
userRoleParameter.DataType = DbType.String;
userRoleParameter.Value = UserRoleId;
userRoleParameter.Direction = ParameterDirection.Input;
parameters.Add(userRoleParameter);
IBSparameter permissionNameParameter = new IBSparameter();
permissionNameParameter.ParameterName = "p_PermissionName";
permissionNameParameter.DataType = DbType.String;
permissionNameParameter.Value = permissionName;
permissionNameParameter.Direction = ParameterDirection.Input;
parameters.Add(permissionNameParameter);
}
DataSet dsPermission = null;
dsPermission = GetDataSet("ERP_Is_Role_HasPermission", parameters);
if (dsPermission != null && Convert.ToBoolean(dsPermission.Tables[0].Rows[0][0]))
{
returnValue = true;
}
}
catch (Exception ex)
{
}
return(returnValue);
}
public List <LoginViewModel> getUserLoginDetail(LoginViewModel userMaster)
{
List <LoginViewModel> loginView = new List <LoginViewModel>();
List <IBSparameter> parameters = new List <IBSparameter>();
try
{
System.Web.HttpContext.Current.Session["UserAccount"] = userMaster.UserAccount;
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = userMaster.UserAccount;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter PasswordParameter = new IBSparameter();
PasswordParameter.ParameterName = "@Password";
PasswordParameter.DataType = DbType.String;
PasswordParameter.Value = userMaster.Password;
PasswordParameter.Direction = ParameterDirection.Input;
parameters.Add(PasswordParameter);
}
else if (DBProvider == ProviderName.MySqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "p_UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = userMaster.UserAccount;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter PasswordParameter = new IBSparameter();
PasswordParameter.ParameterName = "p_Password";
PasswordParameter.DataType = DbType.String;
PasswordParameter.Value = userMaster.Password;
PasswordParameter.Direction = ParameterDirection.Input;
parameters.Add(PasswordParameter);
IBSparameter ApplicationParameter = new IBSparameter();
ApplicationParameter.ParameterName = "p_appName";
ApplicationParameter.DataType = DbType.String;
ApplicationParameter.Value = "Inventory";
ApplicationParameter.Direction = ParameterDirection.Input;
parameters.Add(ApplicationParameter);
}
DataSet dsLoginViewModel = null;
dsLoginViewModel = GetDataSet("ERP_Get_UserDetail", parameters);
var LoginViewCollection = from LoginViewModel in dsLoginViewModel.Tables[0].AsEnumerable()
select new LoginViewModel
{
UserAccount = LoginViewModel.Field <String>("UserAccount"),
SignInStatus = LoginViewModel.Field <String>("SignInStatus"),
RoleId = LoginViewModel.Field <int>("RoleId"),
CompanyCode = LoginViewModel.Field <String>("CompanyCode"),
DBConnectionString = LoginViewModel.Field <String>("DBConnectionString"),
DBProviderName = LoginViewModel.Field <String>("DBProviderName"),
};
loginView = LoginViewCollection.ToList <LoginViewModel>();
}
catch (Exception ex)
{
}
return(loginView);
}
public List <Menus> GetMenu()
{
List <Menus> menuList = new List <Menus>();
List <IBSparameter> parameters = new List <IBSparameter>();
try
{
if (LoggedInUser == null && System.Web.HttpContext.Current.Session["UserAccount"] != null)
{
LoggedInUser = Convert.ToString(System.Web.HttpContext.Current.Session["UserAccount"]);
}
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "@UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
IBSparameter userRoleParameter = new IBSparameter();
userRoleParameter.ParameterName = "@RoleID";
userRoleParameter.DataType = DbType.Int32;
userRoleParameter.Value = UserRoleId;
userRoleParameter.Direction = ParameterDirection.Input;
parameters.Add(userRoleParameter);
}
else if (DBProvider == ProviderName.MySqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "p_UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
IBSparameter passwordParameter = new IBSparameter();
passwordParameter.ParameterName = "p_RoleID";
passwordParameter.DataType = DbType.Int32;
passwordParameter.Value = UserRoleId;
passwordParameter.Direction = ParameterDirection.Input;
parameters.Add(passwordParameter);
}
DataSet dsMenu = null;
dsMenu = GetDataSet("ERP_Get_Menu", parameters);
var menuCollection = from Menus in dsMenu.Tables[0].AsEnumerable()
select new Menus
{
ModuleId = Menus.Field <int>("ModuleId"),
ModuleName = Menus.Field <String>("ModuleName"),
ParentId = Menus.Field <int?>("ParentId"),
ActionName = Menus.Field <String>("ActionName"),
ControllerName = Menus.Field <String>("ControllerName"),
};
menuList = menuCollection.ToList <Menus>();
System.Web.HttpContext.Current.Session["CompanyName"] = "NIBIB NEW"; // take this from output parameter
}
catch (Exception ex)
{
//Logger.Error("NIBIB.EA.DataAccessLayer.AssignmentDal.GetAssignmentList(" + assignmentID + "," + currentUser + "," + isAssignmentOwner + ")", ex);
}
return(menuList);
}
public Category GetCategoryById(int categoryId)
{
List <Category> categoryList = new List <Category>();
// List<IBSparameter> parameters = new List<IBSparameter>();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "@UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
IBSparameter catergoryIdParameter = new IBSparameter();
catergoryIdParameter.ParameterName = "@CategoryId";
catergoryIdParameter.DataType = DbType.String;
catergoryIdParameter.Value = categoryId;
catergoryIdParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryIdParameter);
}
else if (DBProvider == ProviderName.MySqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "p_UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
IBSparameter catergoryIdParameter = new IBSparameter();
catergoryIdParameter.ParameterName = "p_CategoryId";
catergoryIdParameter.DataType = DbType.String;
catergoryIdParameter.Value = categoryId;
catergoryIdParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryIdParameter);
}
DataSet dsCategory = null;
dsCategory = GetDataSet("ERP_Get_CategoryById", parameters);
var CategoryCollection = from Category in dsCategory.Tables[0].AsEnumerable()
select new Category
{
categoryid = Category.Field <int>("categoryid"),
CategoryCode = Category.Field <String>("CategoryCode"),
CategoryName = Category.Field <String>("CategoryName"),
Description = Category.Field <String>("Description"),
};
categoryList = CategoryCollection.ToList <Category>();
}
catch (Exception ex)
{
Logger.Error("CategoriesDAL.GetCategoryById(" + LoggedInUser + "," + CompanyCode + "," + categoryId + ")", ex);
}
return(categoryList[0]);
}
public ReturnResult SaveSupplier(Suppliers supplier)
{
// Suppliers objSupplier = new Suppliers();
ReturnResult returnResult = new ReturnResult();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter SupplierIdParameter = new IBSparameter();
SupplierIdParameter.ParameterName = "@SupplierId";
SupplierIdParameter.DataType = DbType.String;
SupplierIdParameter.Value = supplier.SupplierId;
SupplierIdParameter.Direction = ParameterDirection.Input;
parameters.Add(SupplierIdParameter);
IBSparameter SupplierCodeParameter = new IBSparameter();
SupplierCodeParameter.ParameterName = "@SupplierCode";
SupplierCodeParameter.DataType = DbType.String;
SupplierCodeParameter.Value = supplier.SupplierCode;
SupplierCodeParameter.Direction = ParameterDirection.Input;
parameters.Add(SupplierCodeParameter);
IBSparameter SupplierNameParameter = new IBSparameter();
SupplierNameParameter.ParameterName = "@SupplierName";
SupplierNameParameter.DataType = DbType.String;
SupplierNameParameter.Value = supplier.SupplierName;
SupplierNameParameter.Direction = ParameterDirection.Input;
parameters.Add(SupplierNameParameter);
IBSparameter SupplierContactParameter = new IBSparameter();
SupplierContactParameter.ParameterName = "@ContactName";
SupplierContactParameter.DataType = DbType.String;
SupplierContactParameter.Value = supplier.ContactName;
SupplierContactParameter.Direction = ParameterDirection.Input;
parameters.Add(SupplierContactParameter);
IBSparameter SupplierContactTitleParameter = new IBSparameter();
SupplierContactTitleParameter.ParameterName = "@ContactTitle";
SupplierContactTitleParameter.DataType = DbType.String;
SupplierContactTitleParameter.Value = supplier.ContactTitle;
SupplierContactTitleParameter.Direction = ParameterDirection.Input;
parameters.Add(SupplierContactTitleParameter);
IBSparameter AddressParameter = new IBSparameter();
AddressParameter.ParameterName = "@Address";
AddressParameter.DataType = DbType.String;
AddressParameter.Value = supplier.Address;
AddressParameter.Direction = ParameterDirection.Input;
parameters.Add(AddressParameter);
IBSparameter CityParameter = new IBSparameter();
CityParameter.ParameterName = "@City";
CityParameter.DataType = DbType.String;
CityParameter.Value = supplier.City;
CityParameter.Direction = ParameterDirection.Input;
parameters.Add(CityParameter);
IBSparameter PostalCodeParameter = new IBSparameter();
PostalCodeParameter.ParameterName = "@PostalCode";
PostalCodeParameter.DataType = DbType.String;
PostalCodeParameter.Value = supplier.PostalCode;
PostalCodeParameter.Direction = ParameterDirection.Input;
parameters.Add(PostalCodeParameter);
IBSparameter CountryParameter = new IBSparameter();
CountryParameter.ParameterName = "@Country";
CountryParameter.DataType = DbType.String;
CountryParameter.Value = supplier.Country;
CountryParameter.Direction = ParameterDirection.Input;
parameters.Add(CountryParameter);
IBSparameter Phone1Parameter = new IBSparameter();
Phone1Parameter.ParameterName = "@Phone1";
Phone1Parameter.DataType = DbType.String;
Phone1Parameter.Value = supplier.Phone1;
Phone1Parameter.Direction = ParameterDirection.Input;
parameters.Add(Phone1Parameter);
IBSparameter Phone2Parameter = new IBSparameter();
Phone2Parameter.ParameterName = "@Phone2";
Phone2Parameter.DataType = DbType.String;
Phone2Parameter.Value = supplier.Phone2;
Phone2Parameter.Direction = ParameterDirection.Input;
parameters.Add(Phone2Parameter);
IBSparameter FaxParameter = new IBSparameter();
FaxParameter.ParameterName = "@Fax";
FaxParameter.DataType = DbType.String;
FaxParameter.Value = supplier.Fax;
FaxParameter.Direction = ParameterDirection.Input;
parameters.Add(FaxParameter);
IBSparameter WebSiteParameter = new IBSparameter();
WebSiteParameter.ParameterName = "@Website";
WebSiteParameter.DataType = DbType.String;
WebSiteParameter.Value = supplier.Website;
WebSiteParameter.Direction = ParameterDirection.Input;
parameters.Add(WebSiteParameter);
IBSparameter ContactEmailParameter = new IBSparameter();
ContactEmailParameter.ParameterName = "@ContactEmail";
ContactEmailParameter.DataType = DbType.String;
ContactEmailParameter.Value = supplier.ContactEmail;
ContactEmailParameter.Direction = ParameterDirection.Input;
parameters.Add(ContactEmailParameter);
IBSparameter ReturnParameter = new IBSparameter();
ReturnParameter.ParameterName = "@ReturnValue";
ReturnParameter.DataType = DbType.Int32;
ReturnParameter.Value = "";
ReturnParameter.Direction = ParameterDirection.Output;
parameters.Add(ReturnParameter);
}
//ReturnResult returnValue = new ReturnResult();
return(ExecuteSqlNonQuery("ERP_SAVE_Suppliers", parameters));
//if (returnValue .IsSuccess)
//{
// returnResult.ID = count;
// returnResult.IsSuccess=true;
// returnResult.Message = "Category saved successfully.";
//}
//else
//{
//}
//DbCommand command = database.GetStoredProcCommand("ERP_Save_Category"); // SP name
//database.AddInParameter(command, "@CategoryId", DbType.Int32, category.categoryid);
//database.AddInParameter(command, "@CategoryName", DbType.String, category.categoryname);
//database.AddInParameter(command, "@Description", DbType.String, category.description);
//database.AddInParameter(command, "@LoginUser", DbType.String, loginUser);
//database.ExecuteNonQuery(command);
}
catch (Exception ex)
{
Logger.Error("SupplierDAL.SaveSupplier(" + LoggedInUser + "," + CompanyCode + "," + supplier.SupplierCode + ")", ex);
}
return(returnResult);
}
public ReturnResult SaveCategory(Category category)
{
Category objCategory = new Category();
ReturnResult returnResult = new ReturnResult();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "@UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
IBSparameter catergoryIdParameter = new IBSparameter();
catergoryIdParameter.ParameterName = "@CategoryId";
catergoryIdParameter.DataType = DbType.String;
catergoryIdParameter.Value = category.categoryid;
catergoryIdParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryIdParameter);
IBSparameter catergoryCodeParameter = new IBSparameter();
catergoryCodeParameter.ParameterName = "@CategoryCode";
catergoryCodeParameter.DataType = DbType.String;
catergoryCodeParameter.Value = category.CategoryCode;
catergoryCodeParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryCodeParameter);
IBSparameter catergoryNameParameter = new IBSparameter();
catergoryNameParameter.ParameterName = "@CategoryName";
catergoryNameParameter.DataType = DbType.String;
catergoryNameParameter.Value = category.CategoryName;
catergoryNameParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryNameParameter);
IBSparameter catergoryDescParameter = new IBSparameter();
catergoryDescParameter.ParameterName = "@Description";
catergoryDescParameter.DataType = DbType.String;
catergoryDescParameter.Value = category.Description;
catergoryDescParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryDescParameter);
IBSparameter returnParameter = new IBSparameter();
returnParameter.ParameterName = "@ReturnValue";
returnParameter.DataType = DbType.Int32;
returnParameter.Value = "";
returnParameter.Direction = ParameterDirection.Output;
parameters.Add(returnParameter);
}
else if (DBProvider == ProviderName.MySqlClient)
{
IBSparameter userParameter = new IBSparameter();
userParameter.ParameterName = "p_UserAccount";
userParameter.DataType = DbType.String;
userParameter.Value = LoggedInUser;
userParameter.Direction = ParameterDirection.Input;
parameters.Add(userParameter);
IBSparameter catergoryIdParameter = new IBSparameter();
catergoryIdParameter.ParameterName = "p_CategoryId";
catergoryIdParameter.DataType = DbType.Int32;
catergoryIdParameter.Value = category.categoryid;
catergoryIdParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryIdParameter);
IBSparameter catergoryCodeParameter = new IBSparameter();
catergoryCodeParameter.ParameterName = "p_CategoryCode";
catergoryCodeParameter.DataType = DbType.String;
catergoryCodeParameter.Value = category.CategoryCode;
catergoryCodeParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryCodeParameter);
IBSparameter catergoryNameParameter = new IBSparameter();
catergoryNameParameter.ParameterName = "p_CategoryName";
catergoryNameParameter.DataType = DbType.String;
catergoryNameParameter.Value = category.CategoryName;
catergoryNameParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryNameParameter);
IBSparameter catergoryDescParameter = new IBSparameter();
catergoryDescParameter.ParameterName = "p_Description";
catergoryDescParameter.DataType = DbType.String;
catergoryDescParameter.Value = category.Description;
catergoryDescParameter.Direction = ParameterDirection.Input;
parameters.Add(catergoryDescParameter);
IBSparameter returnParameter = new IBSparameter();
returnParameter.ParameterName = "p_ReturnValue";
returnParameter.DataType = DbType.Int32;
returnParameter.Value = "";
returnParameter.Direction = ParameterDirection.Output;
parameters.Add(returnParameter);
}
//ReturnResult returnValue = new ReturnResult();
return(ExecuteSqlNonQuery("ERP_Save_Category", parameters));
//if (returnValue .IsSuccess)
//{
// returnResult.ID = count;
// returnResult.IsSuccess=true;
// returnResult.Message = "Category saved successfully.";
//}
//else
//{
//}
//DbCommand command = database.GetStoredProcCommand("ERP_Save_Category"); // SP name
//database.AddInParameter(command, "@CategoryId", DbType.Int32, category.categoryid);
//database.AddInParameter(command, "@CategoryName", DbType.String, category.categoryname);
//database.AddInParameter(command, "@Description", DbType.String, category.description);
//database.AddInParameter(command, "@LoginUser", DbType.String, loginUser);
//database.ExecuteNonQuery(command);
}
catch (Exception ex)
{
Logger.Error("CategoriesDAL.SaveCategory(" + LoggedInUser + "," + CompanyCode + "," + category.CategoryCode + ")", ex);
}
return(returnResult);
}
public ReturnResult SaveCompany(CompanyMaster company)
{
CompanyMaster objCompany = new CompanyMaster();
ReturnResult returnResult = new ReturnResult();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter CompanyIDParameter = new IBSparameter();
CompanyIDParameter.ParameterName = "@CompanyID";
CompanyIDParameter.DataType = DbType.String;
CompanyIDParameter.Value = company.CompanyId;
CompanyIDParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyIDParameter);
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter CompanyCodeParameter = new IBSparameter();
CompanyCodeParameter.ParameterName = "@CompanyCode";
CompanyCodeParameter.DataType = DbType.String;
CompanyCodeParameter.Value = company.CompanyCode;
CompanyCodeParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyCodeParameter);
IBSparameter CompanyNameParameter = new IBSparameter();
CompanyNameParameter.ParameterName = "@CompanyName";
CompanyNameParameter.DataType = DbType.String;
CompanyNameParameter.Value = company.CompanyName;
CompanyNameParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyNameParameter);
IBSparameter CompanyRegistrationNoParameter = new IBSparameter();
CompanyRegistrationNoParameter.ParameterName = "@RegistrationNo";
CompanyRegistrationNoParameter.DataType = DbType.String;
CompanyRegistrationNoParameter.Value = company.RegistrationNo;
CompanyRegistrationNoParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyRegistrationNoParameter);
IBSparameter CompanyAddressParameter = new IBSparameter();
CompanyAddressParameter.ParameterName = "@Address";
CompanyAddressParameter.DataType = DbType.String;
CompanyAddressParameter.Value = company.Address;
CompanyAddressParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyAddressParameter);
IBSparameter CompanyCityParameter = new IBSparameter();
CompanyCityParameter.ParameterName = "@City";
CompanyCityParameter.DataType = DbType.String;
CompanyCityParameter.Value = company.City;
CompanyCityParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyCityParameter);
IBSparameter Flag = new IBSparameter();
Flag.ParameterName = "@Flag";
Flag.DataType = DbType.String;
Flag.Value = "I";
Flag.Direction = ParameterDirection.Input;
parameters.Add(Flag);
IBSparameter returnParameter = new IBSparameter();
returnParameter.ParameterName = "@ReturnValue";
returnParameter.DataType = DbType.Int32;
returnParameter.Value = "";
returnParameter.Direction = ParameterDirection.Output;
parameters.Add(returnParameter);
}
return(ExecuteSqlNonQuery("ERP_Save_Company", parameters));
}
catch (Exception ex)
{
Logger.Error("CompanyDAL.SaveCompany(" + LoggedInUser + "," + CompanyCode + "," + company.CompanyCode + ")", ex);
}
return(returnResult);
}
public ReturnResult SaveProduct(ProductMaster product)
{
Category objCategory = new Category();
ReturnResult returnResult = new ReturnResult();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter ProductIdParameter = new IBSparameter();
ProductIdParameter.ParameterName = "@ProductId";
ProductIdParameter.DataType = DbType.String;
ProductIdParameter.Value = product.ProductId;
ProductIdParameter.Direction = ParameterDirection.Input;
parameters.Add(ProductIdParameter);
IBSparameter ProductCodeParameter = new IBSparameter();
ProductCodeParameter.ParameterName = "@ProductCode";
ProductCodeParameter.DataType = DbType.String;
ProductCodeParameter.Value = product.ProductCode;
ProductCodeParameter.Direction = ParameterDirection.Input;
parameters.Add(ProductCodeParameter);
IBSparameter CatergoryNameParameter = new IBSparameter();
CatergoryNameParameter.ParameterName = "@ProductName";
CatergoryNameParameter.DataType = DbType.String;
CatergoryNameParameter.Value = product.CategoryName;
CatergoryNameParameter.Direction = ParameterDirection.Input;
parameters.Add(CatergoryNameParameter);
IBSparameter UOMParameter = new IBSparameter();
UOMParameter.ParameterName = "@UOM";
UOMParameter.DataType = DbType.String;
UOMParameter.Value = product.UOM;
UOMParameter.Direction = ParameterDirection.Input;
parameters.Add(UOMParameter);
IBSparameter BarcodeParameter = new IBSparameter();
BarcodeParameter.ParameterName = "@Barcode";
BarcodeParameter.DataType = DbType.String;
BarcodeParameter.Value = product.BarCode;
BarcodeParameter.Direction = ParameterDirection.Input;
parameters.Add(BarcodeParameter);
IBSparameter CategoryIdParameter = new IBSparameter();
CategoryIdParameter.ParameterName = "@CategoryId";
CategoryIdParameter.DataType = DbType.Int32;
CategoryIdParameter.Value = product.CategoryId;
CategoryIdParameter.Direction = ParameterDirection.Input;
parameters.Add(CategoryIdParameter);
IBSparameter SupplierIdParameter = new IBSparameter();
SupplierIdParameter.ParameterName = "@SupplierId";
SupplierIdParameter.DataType = DbType.Int32;
SupplierIdParameter.Value = product.SupplierId;
SupplierIdParameter.Direction = ParameterDirection.Input;
parameters.Add(SupplierIdParameter);
IBSparameter CompanyPriceParameter = new IBSparameter();
CompanyPriceParameter.ParameterName = "@CompanyPrice";
CompanyPriceParameter.DataType = DbType.Decimal;
CompanyPriceParameter.Value = product.CompanyPrice;
CompanyPriceParameter.Direction = ParameterDirection.Input;
parameters.Add(CompanyPriceParameter);
IBSparameter RePOorderLevelParameter = new IBSparameter();
RePOorderLevelParameter.ParameterName = "@RePOorderLevel";
RePOorderLevelParameter.DataType = DbType.Int32;
RePOorderLevelParameter.Value = product.RePOorderLevel;
RePOorderLevelParameter.Direction = ParameterDirection.Input;
parameters.Add(RePOorderLevelParameter);
IBSparameter RePOorderQuantityParameter = new IBSparameter();
RePOorderQuantityParameter.ParameterName = "@RePOorderQuantity";
RePOorderQuantityParameter.DataType = DbType.Int32;
RePOorderQuantityParameter.Value = product.RePOorderQuantity;
RePOorderQuantityParameter.Direction = ParameterDirection.Input;
parameters.Add(RePOorderQuantityParameter);
//IBSparameter ReSOorderLevelParameter = new IBSparameter();
//ReSOorderLevelParameter.ParameterName = "@ReSOorderLevel";
//ReSOorderLevelParameter.DataType = DbType.Int32;
//ReSOorderLevelParameter.Value = product.ReSOorderLevel;
//ReSOorderLevelParameter.Direction = ParameterDirection.Input;
//parameters.Add(ReSOorderLevelParameter);
//IBSparameter ReSOorderQuantityParameter = new IBSparameter();
//ReSOorderQuantityParameter.ParameterName = "@ReSOorderQuantity";
//ReSOorderQuantityParameter.DataType = DbType.Int32;
//ReSOorderQuantityParameter.Value = product.ReSOorderQuantity;
//ReSOorderQuantityParameter.Direction = ParameterDirection.Input;
//parameters.Add(ReSOorderQuantityParameter);
IBSparameter ReturnParameter = new IBSparameter();
ReturnParameter.ParameterName = "@ReturnValue";
ReturnParameter.DataType = DbType.Int32;
ReturnParameter.Value = "";
ReturnParameter.Direction = ParameterDirection.Output;
parameters.Add(ReturnParameter);
}
//ReturnResult returnValue = new ReturnResult();
return(ExecuteSqlNonQuery("ERP_Save_Product", parameters));
//if (returnValue .IsSuccess)
//{
// returnResult.ID = count;
// returnResult.IsSuccess=true;
// returnResult.Message = "Category saved successfully.";
//}
//else
//{
//}
//DbCommand command = database.GetStoredProcCommand("ERP_Save_Category"); // SP name
//database.AddInParameter(command, "@CategoryId", DbType.Int32, category.categoryid);
//database.AddInParameter(command, "@CategoryName", DbType.String, category.categoryname);
//database.AddInParameter(command, "@Description", DbType.String, category.description);
//database.AddInParameter(command, "@LoginUser", DbType.String, loginUser);
//database.ExecuteNonQuery(command);
}
catch (Exception ex)
{
Logger.Error("ProductDAL.SaveProduct(" + LoggedInUser + "," + CompanyCode + "," + product.ProductCode + ")", ex);
}
return(returnResult);
}
public ReturnResult SaveStore(Stores store)
{
Stores objStore = new Stores();
ReturnResult returnResult = new ReturnResult();
try
{
if (DBProvider == ProviderName.SqlClient)
{
IBSparameter StoreIDParameter = new IBSparameter();
StoreIDParameter.ParameterName = "@StoreID";
StoreIDParameter.DataType = DbType.String;
StoreIDParameter.Value = store.StoreId;
StoreIDParameter.Direction = ParameterDirection.Input;
parameters.Add(StoreIDParameter);
IBSparameter Userparameter = new IBSparameter();
Userparameter.ParameterName = "@UserAccount";
Userparameter.DataType = DbType.String;
Userparameter.Value = LoggedInUser;
Userparameter.Direction = ParameterDirection.Input;
parameters.Add(Userparameter);
IBSparameter StoreNameParameter = new IBSparameter();
StoreNameParameter.ParameterName = "@StoreName";
StoreNameParameter.DataType = DbType.String;
StoreNameParameter.Value = store.StoreName;
StoreNameParameter.Direction = ParameterDirection.Input;
parameters.Add(StoreNameParameter);
IBSparameter StoreCompanyIDParameter = new IBSparameter();
StoreCompanyIDParameter.ParameterName = "@CompanyID";
StoreCompanyIDParameter.DataType = DbType.Int32;
StoreCompanyIDParameter.Value = 1;
StoreCompanyIDParameter.Direction = ParameterDirection.Input;
parameters.Add(StoreCompanyIDParameter);
IBSparameter StoreAddressParameter = new IBSparameter();
StoreAddressParameter.ParameterName = "@Address";
StoreAddressParameter.DataType = DbType.String;
StoreAddressParameter.Value = store.Address;
StoreAddressParameter.Direction = ParameterDirection.Input;
parameters.Add(StoreAddressParameter);
IBSparameter StoreCityParameter = new IBSparameter();
StoreCityParameter.ParameterName = "@City";
StoreCityParameter.DataType = DbType.String;
StoreCityParameter.Value = store.City;
StoreCityParameter.Direction = ParameterDirection.Input;
parameters.Add(StoreCityParameter);
IBSparameter StoreEmailParameter = new IBSparameter();
StoreEmailParameter.ParameterName = "@Email";
StoreEmailParameter.DataType = DbType.String;
StoreEmailParameter.Value = store.Email;
StoreEmailParameter.Direction = ParameterDirection.Input;
parameters.Add(StoreEmailParameter);
IBSparameter Flag = new IBSparameter();
Flag.ParameterName = "@Flag";
Flag.DataType = DbType.String;
Flag.Value = "I";
Flag.Direction = ParameterDirection.Input;
parameters.Add(Flag);
//IBSparameter returnParameter = new IBSparameter();
//returnParameter.ParameterName = "@ReturnValue";
//returnParameter.DataType = DbType.Int32;
//returnParameter.Value = "";
//returnParameter.Direction = ParameterDirection.Output;
//parameters.Add(returnParameter);
}
return(ExecuteSqlNonQuery("ERP_Save_Store", parameters));
}
catch (Exception ex)
{
// Logger.Error("CompanyDAL.SaveCompany(" + LoggedInUser + "," + CompanyCode + "," + company.CompanyCode + ")", ex);
}
return(returnResult);
}
