// Retrieve manufactures list from database
public List <ManufacturerProperties> getManufacturersList(string status)
{
ManufacturerProperties manufacturerProperties;
List <ManufacturerProperties> manufacturersList = new List <ManufacturerProperties>();
DataSet resultDataset;
try {
string selectQueryString = "SELECT MANUFACTURER_ID, MANUFACTURER_NAME, MANUFACTURER_DETAIL, MANUFACTURER_STATUS FROM MANUFACTURER WHERE MANUFACTURER_STATUS=@STATUS";
List <KeyValuePair <string, string> > tableParamsValues = new List <KeyValuePair <string, string> >();
tableParamsValues.Add(new KeyValuePair <string, string>("@STATUS", status));
resultDataset = DatabaseConnectionHandler.executeSelectQuery(selectQueryString, tableParamsValues);
if (resultDataset != null)
{
foreach (DataRow resultrow in resultDataset.Tables[0].Rows)
{
manufacturerProperties = new ManufacturerProperties();
manufacturerProperties.Manufacturer_Id = resultrow["Manufacturer_Id"].ToString();
manufacturerProperties.Manufacturer_Name = resultrow["Manufacturer_Name"].ToString();
manufacturerProperties.Manufacturer_Detail = resultrow["Manufacturer_Detail"].ToString();
manufacturerProperties.Manufacturer_Status = resultrow["manufacturer_Status"].ToString();
manufacturersList.Add(manufacturerProperties);
}
}
}catch (Exception exp) { Console.WriteLine(exp.StackTrace); }
return(manufacturersList);
}
//deactive/remove the manufacturer from database
public bool deActivateManufacturer(ManufacturerProperties manufacturerProperties, string userInfo)
{
bool result = false;
try {
string updateQueryString = "UPDATE MANUFACTURER SET MANUFACTURER_STATUS=@STATUS,MODIFIED_BY=@MODIFIED_BY,MODIFIED_DATE=@MODIFIED_DATE WHERE MANUFACTURER_ID=@MANUFACTURER_ID";
List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >();
tableQueryData.Add(new KeyValuePair <string, string>("@STATUS", manufacturerProperties.Manufacturer_Status));
tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_ID", manufacturerProperties.Manufacturer_Id));
tableQueryData.Add(new KeyValuePair <string, string>("@MODIFIED_BY", userInfo));
tableQueryData.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime));
result = DatabaseConnectionHandler.executeUpdateQuery(updateQueryString, tableQueryData);
}catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(result);
}
//Add new manufacturer in inventory
public bool addNewManufacturer(ManufacturerProperties manufacturerInfo, string userInfo)
{
bool result = false;
try {
string insertNewManufacturerQuery = "INSERT INTO MANUFACTURER(MANUFACTURER_ID,MANUFACTURER_NAME,MANUFACTURER_DETAIL,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,MANUFACTURER_STATUS) VALUES(@MANUFACTURER_ID,@MANUFACTURER_NAME,@MANUFACTURER_DETAIL,@CREATED_BY,@CREATED_DATE,@MODIFIED_BY,@MODIFIED_DATE,@MANUFACTURER_STATUS)";
List <KeyValuePair <string, string> > tableQueryData = new List <KeyValuePair <string, string> >();
tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_ID", manufacturerInfo.Manufacturer_Id));
tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_NAME", manufacturerInfo.Manufacturer_Name));
tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_DETAIL", manufacturerInfo.Manufacturer_Detail));
tableQueryData.Add(new KeyValuePair <string, string>("@CREATED_BY", userInfo));
tableQueryData.Add(new KeyValuePair <string, string>("@CREATED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime));
tableQueryData.Add(new KeyValuePair <string, string>("@MODIFIED_BY", userInfo));
tableQueryData.Add(new KeyValuePair <string, string>("@MODIFIED_DATE", com.app.utlitiy.BusinessUtlities.getCurrentDateTime));
tableQueryData.Add(new KeyValuePair <string, string>("@MANUFACTURER_STATUS", manufacturerInfo.Manufacturer_Status));
result = DatabaseConnectionHandler.executeInsertDbQuery(insertNewManufacturerQuery, tableQueryData);
}catch (Exception ex) { Console.WriteLine(ex.StackTrace); }
return(result);
}
private void buttonAddManufacturer_Click(object sender, EventArgs e)
{
bool result = false;
//************************ TESTING DATA
string userInfo = _userSessionInformation.User_Id;
try
{
if (radioButtonAddNewManufacturer.Checked)
{
ManufacturerProperties manufacturerProperties = new ManufacturerProperties();
try
{
manufacturerProperties.Manufacturer_Id = textBoxManufactureId.Text;
manufacturerProperties.Manufacturer_Name = textBoxManufacturerName.Text;
manufacturerProperties.Manufacturer_Detail = textBoxManfacturerDescriptions.Text;
manufacturerProperties.Manufacturer_Status = textBoxStatus.Text;
}
catch (Exception ex)
{
MessageBox.Show("PLEASE PROVIDE APPROPRIATE VALUES", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Console.WriteLine(ex.StackTrace);
}
result = inventoryManagementHandler.addNewManufacturer(manufacturerProperties, userInfo);
if (result)
{
fillManufacturersGridView(inventoryManagementHandler.getmanufacturersData("ACTIVE"));
MessageBox.Show("NEW MANUFACTURER ADDED SUCCESSFULLY", "MANUFACTURER", MessageBoxButtons.OK, MessageBoxIcon.Information);
refreshProductList();
loadManufacturerGridView();
loadManufacturersComboBox();
}
}
else if (radioButtonRemoveManufacturer.Checked)
{
ManufacturerProperties manufacturerProperties = new ManufacturerProperties();
try
{
manufacturerProperties.Manufacturer_Id = textBoxManufactureId.Text;
manufacturerProperties.Manufacturer_Name = textBoxManufacturerName.Text;
manufacturerProperties.Manufacturer_Detail = textBoxManfacturerDescriptions.Text;
manufacturerProperties.Manufacturer_Status = comboBoxStatus.SelectedItem.ToString();
result = inventoryManagementHandler.removeManufacturer(manufacturerProperties, userInfo);
if (result)
{
MessageBox.Show("MANUFACTURER REMOVED SUCCESSFULLY", "MANUFACTURER", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadManufacturerGridView();
loadManufacturersComboBox();
}
}
catch (Exception ex)
{
MessageBox.Show("PLEASE ENTER THE MANUFACTURER ID", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex) { Console.WriteLine("Validation exception occured", ex.StackTrace); }
}
public bool removeManufacturer(ManufacturerProperties manufacturerProperites, string currentUserId)
{
return(inventoryDbProcessHandler.deActivateManufacturer(manufacturerProperites, currentUserId));
}
public bool addNewManufacturer(ManufacturerProperties manufacturerInfo, string userInfo)
{
return(inventoryDbProcessHandler.addNewManufacturer(manufacturerInfo, userInfo));
}
