// 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)); }