private void itemSetupToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
ItemSetup items = new ItemSetup();
items.Show();
}
private void saveButton_Click(object sender, EventArgs e)
{
try
{
ItemSetup insGetSet = new ItemSetup();
insGetSet.CatagoryName = categoryComboBox.Text;
insGetSet.ComapanyName = companyComboBox.Text;
insGetSet.ItemName = itemTextBox.Text;
insGetSet.ReorderLavel = reorderTextBox.Text;
ItemSetupManager companymanager = new ItemSetupManager();
bool chk = companymanager.Insert(insGetSet);
if (chk)
{
MessageBox.Show("Data Saved", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Try Again");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public List <ItemSetup> GetAllItemsByCompany(int id)
{
string query = "SELECT * FROM ItemSetup WHERE CompanyId =" + id;
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <ItemSetup> items = new List <ItemSetup>();
while (Reader.Read())
{
ItemSetup itemSetup = new ItemSetup();
itemSetup.Id = Convert.ToInt32(Reader["Id"]);
itemSetup.CategoryId = Convert.ToInt32(Reader["CategoryId"]);
itemSetup.CompanyId = Convert.ToInt32(Reader["CompanyId"]);
itemSetup.ReorderLevel = Convert.ToInt32(Reader["ReorderLevel"]);
itemSetup.ItemName = Reader["ItemName"].ToString();
items.Add(itemSetup);
}
Connection.Close();
return(items);
}
internal void Update(string connectionString, ItemSetup objItemSetup)
{
try
{
var storedProcedureComandTest = "exec [spUpdatematMaterialSetup] " +
objItemSetup.ItemID + "," +
objItemSetup.ItemCategoryID + "," +
objItemSetup.ItemTypeID + "," +
objItemSetup.ItemPropertySetID + "," +
objItemSetup.ItemUsageID + ",'" +
objItemSetup.ModelNo + "'," +
objItemSetup.UnitID + ",'" +
objItemSetup.HsCode + "','" +
objItemSetup.ItemCode + "','" +
objItemSetup.Specification + "'," +
objItemSetup.OpenningBalance + ",'" +
objItemSetup.SupplierID + "'," +
objItemSetup.IsVATAbleItem + "," +
objItemSetup.CoaSalesAccNo + "," +
objItemSetup.CoaStockAccNo + "," +
objItemSetup.CoacgsAccNo + "," +
objItemSetup.CoaSalesRetAccNo + ",'" +
objItemSetup.EntryUserName + "'," +
objItemSetup.BreakUpQuantity + ",'" +
objItemSetup.ReOrderLevel + "'," +
objItemSetup.BreakUpUnitD + "," +
objItemSetup.MinimumQuantity;
clsDataManipulation.StoredProcedureExecuteNonQuery(connectionString, storedProcedureComandTest);
}
catch (Exception msgException)
{
throw msgException;
}
}
public List <ItemSetup> SearchItems(string query)
{
command = new SqlCommand(query, connection);
List <ItemSetup> searchItemList = new List <ItemSetup>();
int sl = 1;
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
ItemSetup aSearchItem = new ItemSetup();
aSearchItem.CatagoryId = sl++; //categoryId = SL
aSearchItem.CompanyName = reader["CompanyName"].ToString();
aSearchItem.ItemName = reader["ItemName"].ToString();
aSearchItem.AvailableQuantity = Convert.ToInt32(reader["AvailableQuantity"]);
aSearchItem.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]);
searchItemList.Add(aSearchItem);
}
reader.Close();
connection.Close();
return(searchItemList);
}
public string Save(ItemSetup itemSetup)
{
int check = itemSetupGateway.Save(itemSetup);
if (check > 0)
{
return("Save Successful");
}
return("Save Faild");
}
public int SaveGateway(ItemSetup itemSetup)
{
string query = "INSERT INTO ItemSetup VALUES('" + itemSetup.CategoryId + "','" + itemSetup.CompanyId + "','" + itemSetup.ItemName + "','" + itemSetup.ReorderLevel + "')";
Command = new SqlCommand(query, Connection);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
protected void TreeViewCategory_SelectedNodeChanged(object sender, EventArgs e)
{
try
{
_objItemCategorySetup = new ItemCategorySetup();
_objItemCategorySetup.ItemCategoryID = Convert.ToInt32(TreeViewCategory.SelectedNode.Value);
var parentID = TreeViewCategory.SelectedNode.Parent == null ? _objItemCategorySetup.ItemCategoryID : Convert.ToInt32(TreeViewCategory.SelectedNode.Parent.Value);
var childID = 0;
if (TreeViewCategory.SelectedNode.ChildNodes.Count > 0)
{
childID = Convert.ToInt32(TreeViewCategory.SelectedNode.ChildNodes[0].Value.ToString());
}
int countIDDigit = Convert.ToInt32(_objItemCategorySetup.ItemCategoryID.ToString().Length.ToString());
int countChildIDDigit = Convert.ToInt32(childID.ToString().Length.ToString());
if (countIDDigit == 9)
{
ddlParentCategory.SelectedValue = _objItemCategorySetup.ItemCategoryID.ToString();
ddlCategory.SelectedValue = _objItemCategorySetup.ItemCategoryID.ToString();
CheckBoxAddItem.Enabled = true;
txtCategoryName.Focus();
txtCategoryName.Enabled = true;
PanelItemDetails.Visible = false;
btnUpdate.Visible = false;
if (countChildIDDigit == 8)
{
txtCategoryName.Enabled = false;
}
}
else
{
ddlParentCategory.SelectedValue = parentID.ToString();
ddlCategory.SelectedValue = parentID.ToString();
txtCategoryName.Enabled = false;
CheckBoxAddItem.Enabled = false;
PanelItemDetails.Visible = true;
LoadDropDownListData(ddlItemTypeIDUpdate, ddlUnitUpdate, ddlBreakupUnitUpdate, ddlItemUsageIDUpdate, ddlRelatedSupplierUpdate, ddlSalesAccountNoUpdate,
ddlStockAccountNoUpdate, ddlCOGSAccountNoUpdate, ddlSalesReturnAccountUpdate);
_objItemSetup = new ItemSetup();
_objItemSetup.ItemID = Convert.ToInt32(TreeViewCategory.SelectedNode.Value);
Session["itemID"] = _objItemSetup.ItemID;
ShowItemDetails(_objItemSetup);
btnUpdate.Visible = true;
}
}
catch (Exception msgException)
{
clsTopMostMessageBox.Show(msgException.Message);
}
}
internal DataTable GetItemDetails(string connectionString, ItemSetup _objItemSetup)
{
try
{
DataTable dtItemDetails = null;
var storedProcedureComandTest = "exec [spGetDetailsmatMaterialSetup] " + _objItemSetup.ItemID + "";
dtItemDetails = clsDataManipulation.GetData(connectionString, storedProcedureComandTest);
return(dtItemDetails);
}
catch (Exception msgException)
{
throw msgException;
}
}
private bool IsItemExists(ItemSetup itemSetup)
{
query = "SELECT * FROM itemTable WHERE CompanyId = '" + itemSetup.CompanyId + "' AND ItemName='" + itemSetup.ItemName + "' ";
command = new SqlCommand(query, connection);
connection.Open();
reader = command.ExecuteReader();
bool check = reader.HasRows;
reader.Close();
connection.Close();
return(check);
}
public int Save(ItemSetup itemSetup)
{
if (IsItemExists(itemSetup) == false)
{
query = "INSERT INTO itemTable VALUES ('" + itemSetup.CatagoryId + "', '" + itemSetup.CompanyId + "', '" +
itemSetup.ItemName + "'," + itemSetup.ReorderLevel + ", " + itemSetup.AvailableQuantity + " )";
command = new SqlCommand(query, connection);
connection.Open();
int check = command.ExecuteNonQuery();
connection.Close();
return(check);
}
return(-1);
}
internal DataTable GetItemDetails2(string connectionString, ItemSetup _objItemSetup)
{
DataTable dtItemDetails = null;
try
{
var storedProcedureComandTest = " SELECT * FROM matMaterialSetup where ItemID =" + _objItemSetup.ItemCode + "";
dtItemDetails = clsDataManipulation.GetData(connectionString, storedProcedureComandTest);
return(dtItemDetails);
}
catch
{
return(dtItemDetails);
}
}
public string SaveManager(ItemSetup itemSetup)
{
if (itemSetupGateway.IsItemNameExist(itemSetup.ItemName))
{
return("Item Name already exists !");
}
else
{
int row = itemSetupGateway.SaveGateway(itemSetup);
if (row > 0)
{
return("Save Successful !");
}
else
{
return("Saving Failed !");
}
}
}
private void ShowItemDetails(ItemSetup objItemSetup)
{
try
{
DataTable dtItemDetails = null;
_objItemSetupController = new ItemSetupController();
dtItemDetails = _objItemSetupController.GetItemDetails(_connectionString, objItemSetup);
foreach (DataRow rowNo in dtItemDetails.Rows)
{
txtItemCodeUpdate.Text = rowNo["ItemCode"].ToString();
txtItemNameUpdate.Text = rowNo["ModelNo"].ToString();
ddlItemTypeIDUpdate.SelectedValue = rowNo["ItemTypeID"].ToString() == null ? "-1" : rowNo["ItemTypeID"].ToString();
ddlItemUsageIDUpdate.SelectedValue = rowNo["ItemUsageID"].ToString() == null ? "-1" : rowNo["ItemUsageID"].ToString();
ddlRelatedSupplierUpdate.SelectedValue = rowNo["SupplierID"].ToString() == "" ? "-1" : rowNo["SupplierID"].ToString();
txtDescriptionUpdate.Text = rowNo["Specification"].ToString();
txtHSCodeUpdate.Text = rowNo["HSCode"].ToString();
txtOpeningBalanceUpdate.Text = rowNo["OpenningBalance"].ToString();
ddlUnitUpdate.SelectedValue = rowNo["UnitID"].ToString() == null ? "-1" : rowNo["UnitID"].ToString();
txtBreakUpQuantityUpdate.Text = rowNo["BreakUpQuantity"].ToString();
ddlBreakupUnitUpdate.SelectedValue = rowNo["BreakUpUnitID"].ToString() == null ? "-1" : rowNo["BreakUpUnitID"].ToString();
txtReOrderLevelUpdate.Text = rowNo["ReOrderLevel"].ToString();
txtMinimumQuantityUpdate.Text = rowNo["MinimumBal"].ToString();
ddlSalesAccountNoUpdate.SelectedValue = rowNo["COASalesAccNo"].ToString() == null ? "-1" : rowNo["COASalesAccNo"].ToString();
ddlStockAccountNoUpdate.SelectedValue = rowNo["COAStockAccNo"].ToString() == null ? "-1" : rowNo["COAStockAccNo"].ToString();
ddlCOGSAccountNoUpdate.SelectedValue = rowNo["COACGSAccNo"].ToString() == null ? "-1" : rowNo["COACGSAccNo"].ToString();
ddlSalesReturnAccountUpdate.SelectedValue = rowNo["COASalesRetAccNo"].ToString() == null ? "-1" : rowNo["COASalesRetAccNo"].ToString();
var vatValue = rowNo["IsVATableItem"].ToString();
if (Convert.ToBoolean(vatValue) == true)
{
CheckBoxIsVATUpdate.Checked = true;
}
else
{
CheckBoxIsVATUpdate.Checked = false;
}
}
}
catch (Exception msgException)
{
throw msgException;
}
}
void SetupBuildMenu()
{
foreach (Transform child in BuildItemsHolder.transform)
{
GameObject.Destroy(child.gameObject);
}
foreach (UIElement element in UIElements)
{
if (element.isActive)
{
var inst = Instantiate(BuildContentItem, BuildItemsHolder.transform);
ItemSetup setup = inst.GetComponent <ItemSetup>();
setup.rendTexture = element.prefabIcon;
setup.radius = 2;
setup.textureHeight = element.prefabIcon.height;
setup.textureWidth = element.prefabIcon.width;
setup.prefab = element.prefab;
setup.SetIcon();
}
}
}
public bool Insert(ItemSetup it)
{
string query = @"INSERT ItemSetup (catagoryName,companyName,ItemName,ReorderLavel) Values (@catagoryName,@companyName,@ItemName,@ReorderLavel)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@catagoryName", it.CatagoryName);
cmd.Parameters.AddWithValue("@companyName", it.ComapanyName);
cmd.Parameters.AddWithValue("@ItemName", it.ItemName);
cmd.Parameters.AddWithValue("@ReorderLavel", it.ReorderLavel);
con.Open();
int rowAffect = cmd.ExecuteNonQuery();
con.Close();
if (rowAffect > 0)
{
return(true);
}
else
{
return(false);
}
}
private void AssignItemValuesForUpdate()
{
try
{
_objItemSetup = new ItemSetup();
_objItemSetup.ItemCategoryID = Convert.ToInt32(ddlParentCategory.SelectedValue);
_objItemSetup.Specification = txtDescriptionUpdate.Text == string.Empty ? null : txtDescriptionUpdate.Text;
_objItemSetup.HsCode = txtHSCodeUpdate.Text == string.Empty ? null : txtHSCodeUpdate.Text;
_objItemSetup.IsVATAbleItem = CheckBoxIsVATUpdate.Checked == true ? true : false;
_objItemSetup.SupplierID = ddlRelatedSupplierUpdate.SelectedValue == "-1" ? null : ddlRelatedSupplierUpdate.SelectedValue;
_objItemSetup.OpenningBalance = txtOpeningBalanceUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtOpeningBalanceUpdate.Text);
_objItemSetup.CoaSalesAccNo = Convert.ToInt32(ddlSalesAccountNoUpdate.SelectedValue);
_objItemSetup.CoaStockAccNo = Convert.ToInt32(ddlStockAccountNoUpdate.SelectedValue);
_objItemSetup.CoacgsAccNo = Convert.ToInt32(ddlCOGSAccountNoUpdate.SelectedValue);
_objItemSetup.CoaSalesRetAccNo = Convert.ToInt32(ddlSalesReturnAccountUpdate.SelectedValue);
_objItemSetup.EntryUserName = Session["entryUserCode"].ToString();
_objItemSetup.ItemID = Convert.ToInt32(Session["itemID"].ToString());//
_objItemSetup.ModelNo = txtItemNameUpdate.Text == string.Empty ? null : txtItemNameUpdate.Text;
_objItemSetup.UnitID = Convert.ToInt32(ddlUnitUpdate.SelectedValue);
_objItemSetup.ItemCode = txtItemCodeUpdate.Text == string.Empty ? null : txtItemCodeUpdate.Text;
_objItemSetup.ItemTypeID = Convert.ToInt32(ddlItemTypeIDUpdate.SelectedValue);
_objItemSetup.ItemPropertySetID = 1;
_objItemSetup.ItemUsageID = Convert.ToInt32(ddlItemUsageIDUpdate.SelectedValue);
_objItemSetup.BreakUpQuantity = txtBreakUpQuantityUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtBreakUpQuantityUpdate.Text);
_objItemSetup.ReOrderLevel = txtReOrderLevelUpdate.Text == string.Empty ? null : txtReOrderLevelUpdate.Text;
_objItemSetup.BreakUpUnitD = Convert.ToInt32(ddlBreakupUnitUpdate.SelectedValue) == -1 ? 0 : Convert.ToInt32(ddlBreakupUnitUpdate.SelectedValue);
_objItemSetup.MinimumQuantity = txtMinimumQuantityUpdate.Text == string.Empty ? 0 : Convert.ToInt32(txtMinimumQuantityUpdate.Text);
_objItemSetupController = new ItemSetupController();
_objItemSetupController.Update(_connectionString, _objItemSetup);
ClearAfterUpdate();
TreeViewCategory.Nodes.Clear();
PopulateRootLevel();
}
catch (Exception msgException)
{
throw msgException;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
if (itemNameTextBox.Text.ToString() != "")
{
ItemSetup itemSetup = new ItemSetup();
if (CatagoryDropDownList.Text != "0" && CompanyDropDownList.Text != "0")
{
itemSetup.CatagoryId = Convert.ToInt32(CatagoryDropDownList.SelectedValue);
itemSetup.CompanyId = Convert.ToInt32(CompanyDropDownList.SelectedValue);
itemSetup.ItemName = itemNameTextBox.Text;
if (ReorderLevelTextBox.Text.ToString() == "")
{
itemSetup.ReorderLevel = 0;
}
else
{
itemSetup.ReorderLevel = Convert.ToInt32(ReorderLevelTextBox.Text);
}
outputLabel.Text = itemSetupManager.Save(itemSetup);
itemNameTextBox.Text = "";
ReorderLevelTextBox.Text = "0";
}
else
{
outputLabel.Text = "Please Select an Item";
outputLabel.ForeColor = Color.Orange;
}
}
else
{
outputLabel.Text = "Please Enter a Item Name";
outputLabel.ForeColor = Color.Orange;
}
}
public bool Insert(ItemSetup st)
{
bool chk = rs.Insert(st);
return(chk);
}
protected void itemSaveButton_Click(object sender, EventArgs e)
{
ItemSetup itemSetup = new ItemSetup();
string checkCompany = companyDropDownList.SelectedItem.Text;
string checkCategory = categoryDropDownList.SelectedItem.Text;
if (itemNameTextBox.Text == "" && !(checkCompany.Equals("--Select--") || checkCategory.Equals("--Select--")))
{
outputLabel.Text = "Please fill Up Item Name textBox!";
itemNameTextBox.Text = "";
}
else if (reorderLevelTextBox.Text == "" && !(checkCompany.Equals("--Select--") || checkCategory.Equals("--Select--")))
{
outputLabel.Text = "Please fill Up reorder level textBox!";
itemNameTextBox.Text = "";
reorderLevelTextBox.Text = "0";
}
else if (!(checkCompany.Equals("--Select--") || checkCategory.Equals("--Select--")))
{
string intCheck = itemNameTextBox.Text;
string reorderCheck = reorderLevelTextBox.Text;
int count = 0, z = 0;
for (int i = 0; i < intCheck.Length; i++)
{
if (intCheck[i] >= '0' && intCheck[i] <= '9')
{
count++;
}
}
for (int i = 0; i < reorderCheck.Length; i++)
{
if ((reorderCheck[i] >= 'a' && reorderCheck[i] <= 'z') || (reorderCheck[i] >= 'A' && reorderCheck[i] <= 'Z') || !(reorderCheck[i] >= '0' && reorderCheck[i] <= '9'))
{
z++;
}
}
if (count > 0)
{
outputLabel.Text = "Please enter a string value in item name textbox";
}
else if (z > 0)
{
outputLabel.Text = "Please enter an integer value in reorder level textbox";
}
else
{
itemSetup.CategoryId = Convert.ToInt32(categoryDropDownList.SelectedValue);
itemSetup.CompanyId = Convert.ToInt32(companyDropDownList.SelectedValue);
itemSetup.ItemName = itemNameTextBox.Text;
itemSetup.ReorderLevel = Convert.ToInt32(reorderLevelTextBox.Text);
//int r = Convert.ToInt32(reorderLevelTextBox.Text);
////if (r < 5)
////{
//// outputLabelReorder.Text = "Reorder level is under 5 !";
////}
outputLabel.Text = itemSetupManager.SaveManager(itemSetup);
}
itemNameTextBox.Text = "";
reorderLevelTextBox.Text = "";
}
else
{
outputLabel.Text = "Please select your desired things from dropdown list !";
itemNameTextBox.Text = "";
reorderLevelTextBox.Text = "";
}
itemNameTextBox.Text = "";
reorderLevelTextBox.Text = "0";
}
