private void companySaveButton_Click(object sender, EventArgs e)
{
// Regex Name = new Regex(@"^[a-zA-Z]+(([',. -][a-zA-Z ])?[a-zA-Z]*)*$");
if (!Ch.IsMatch(companyTextBox.Text.Trim()))
{
cMessageBox.Information("Something went wrong");
}
else
{
CompanyModel companyModel = new CompanyModel();
companyModel.Name = companyTextBox.Text.Trim();
SetupGateway companyGateway = new SetupGateway();
bool isExist = companyGateway.IsExistCompany(companyModel);
if (isExist)
{
cMessageBox.Warning("Company Name Already Exist");
}
else
{
int rowAffect = companyGateway.SaveCompany(companyModel);
if (rowAffect > 0)
{
cMessageBox.Success("Company Successfully Saved");
CompanySetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Failed to Save, Please Try Again");
CompanySetup_Load(sender, e);
}
}
} // Expression check else function end here......
}
// Items Section Code
private void itemSaveButton_Click(object sender, EventArgs e)
{
if (!CN.IsMatch(itemNameTextBox.Text.Trim()) || !Nu.IsMatch(itemPriceTextBox.Text.Trim()) ||
catagoryListBox.SelectedValue == null || companyListBox.SelectedValue == null)
{
cMessageBox.Warning("Please Make Sure That Your All Input is Correct");
}
else
{
ItemsModel itemsModel = new ItemsModel();
itemsModel.CatagoryID = Convert.ToInt32(catagoryListBox.SelectedValue);
itemsModel.CompanyID = Convert.ToInt32(companyListBox.SelectedValue);
itemsModel.Name = itemNameTextBox.Text.Trim();
itemsModel.Price = Convert.ToInt32(itemPriceTextBox.Text.Trim());
SetupGateway itemGateway = new SetupGateway();
bool isItemExist = itemGateway.IsItemExists(itemsModel);
if (isItemExist == true)
{
cMessageBox.Information("Item Already Exist");
}
else
{
int rowAffect = itemGateway.SaveItem(itemsModel);
if (rowAffect > 0)
{
cMessageBox.Success("Item Successfully Saved");
ItemSetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Faild to Save, Please Try Again");
}
}
}
}
public void ListofCompany()
{
// Companay Section Code
SetupGateway setupGateway = new SetupGateway();
List <CompanyModel> companyList = setupGateway.GetAllCompany();
if (companyList != null)
{
companyGridview.Rows.Clear();
totalCompanyLabel.Text = "Total : " + companyList.Count + " Companies Found";
companyGridview.ColumnCount = 3;
companyGridview.Columns[0].Name = "SL";
companyGridview.Columns[0].Width = 60;
companyGridview.Columns[1].Name = "ID";
companyGridview.Columns[1].Width = 60;
companyGridview.Columns[2].Name = "Company Name";
companyGridview.Columns[2].Width = 200;
// companyGridview.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
int rn = 0;
foreach (CompanyModel company in companyList)
{
int inc = companyList.Count;
if (inc > rn)
{
rn++;
}
companyGridview.Rows.Add(rn, company.Id, company.Name);
}
}
}
private void CompanyUpdateButton_Click(object sender, EventArgs e)
{
if (companyIdHidden.Text.Trim() != String.Empty && Ch.IsMatch(companyTextBox.Text.Trim()))
{
SetupGateway setupGateway = new SetupGateway();
CompanyModel companyModel = new CompanyModel();
companyModel.Name = companyTextBox.Text.Trim();
companyModel.Id = Convert.ToInt32(companyIdHidden.Text.Trim());
bool isExist = setupGateway.IsExistCompany(companyModel);
if (isExist)
{
cMessageBox.Warning("Company Name Already Exist");
}
else
{
int rowAffect = setupGateway.UpdateCompany(companyModel);
if (rowAffect > 0)
{
cMessageBox.Success("Company Name Updated Successfully");
CompanySetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Failed to Update");
CompanySetup_Load(sender, e);
}
}
}
}
private void catagorySaveButton_Click(object sender, EventArgs e)
{
if (!Ch.IsMatch(catagoryTextBox.Text.Trim()))
{
cMessageBox.Warning("Invaild Input Detected");
}
else
{
CatagoryModel catagoryModel = new CatagoryModel();
catagoryModel.Name = catagoryTextBox.Text.Trim();
SetupGateway catagoryGateway = new SetupGateway();
bool isExist = catagoryGateway.IsExists(catagoryModel);
if (isExist == true)
{
cMessageBox.Information("Category Already Exist");
}
else
{
int rowAffect = catagoryGateway.SaveCatagory(catagoryModel);
if (rowAffect > 0)
{
cMessageBox.Success("Category Successfully Saved");
CatagorySetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Failed To Save Category, Try Again");
CatagorySetup_Load(sender, e);
}
}
}
}
public void CatagoriesList()
{
catagoryGridview.Rows.Clear();
SetupGateway setupGateway = new SetupGateway();
List <CatagoryModel> catagorylist = setupGateway.GetAllCatagory();
if (catagorylist != null)
{
totalCatagoryLabel.Text = "TotaL : " + catagorylist.Count + " Categories Found";
catagoryGridview.ColumnCount = 3;
catagoryGridview.Columns[0].Name = "SL";
catagoryGridview.Columns[0].Width = 60;
catagoryGridview.Columns[1].Name = "ID";
catagoryGridview.Columns[1].Width = 60;
catagoryGridview.Columns[2].Name = "Category Name";
catagoryGridview.Columns[2].Width = 200;
// catagoryGridview.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
int rn = 0;
foreach (CatagoryModel catagory in catagorylist)
{
int inc = catagorylist.Count;
if (inc > rn)
{
rn++;
}
catagoryGridview.Rows.Add(rn, catagory.Id, catagory.Name);
}
}
}
private void CatagoryUpdateButton_Click(object sender, EventArgs e)
{
SetupGateway setupGateway = new SetupGateway();
if (idhiddenLabel.Text.Trim() != String.Empty && Ch.IsMatch(catagoryTextBox.Text.Trim()))
{
CatagoryModel catagory = new CatagoryModel();
catagory.Name = catagoryTextBox.Text.Trim();
catagory.Id = Convert.ToInt32(idhiddenLabel.Text);
bool isExist = setupGateway.IsExists(catagory);
if (isExist == true)
{
cMessageBox.Information("Category Already Exist");
}
else
{
int rowAffect = setupGateway.UpdateCatagory(catagory);
if (rowAffect > 0)
{
cMessageBox.Success("Category Updated");
CatagorySetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Faild to Updated Category");
CatagorySetup_Load(sender, e);
}
}
}
}
private void History_Load(object sender, EventArgs e)
{
// Hide Something
startClander.Visible = false;
endClander.Visible = false;
exportButton.Visible = false;
ItemListBox.DataSource = null;
startDate.Text = "";
endDate.Text = "";
historyGridView.Rows.Clear();
// Load Data To catagory and CompanyList
SetupGateway setupGateway = new SetupGateway();
List <CatagoryModel> catagorylist = setupGateway.GetAllCatagory();
List <CompanyModel> companyList = setupGateway.GetAllCompany();
if (catagorylist != null)
{
var catagoryList = catagorylist.Select(x => new
{
Value = x.Id,
Text = x.Name
}).ToList();
catagoryListBox.ValueMember = "Value";
catagoryListBox.DisplayMember = "Text";
catagoryListBox.DataSource = catagoryList;
catagoryListBox.SelectedValue = 0;
catagoryListBox.SelectedText = "--Select Category--";
}
else
{
catagoryListBox.SelectedValue = 0;
catagoryListBox.SelectedText = "--No Categories Found--";
}
if (companyList != null)
{
var companylist = companyList.Select(x => new
{
Value = x.Id,
Text = x.Name
}).ToList();
companyListBox.ValueMember = "Value";
companyListBox.DisplayMember = "Text";
companyListBox.DataSource = companylist;
companyListBox.SelectedValue = 0;
companyListBox.SelectedText = "--Select Company--";
}
else
{
companyListBox.SelectedValue = 0;
companyListBox.SelectedText = "--No Companies Found--";
}
}
private void ItemSetup_Load(object sender, EventArgs e)
{
itemsGridView.Rows.Clear();
itemNameTextBox.Text = "";
itemPriceTextBox.Text = "";
itemsIdHidden.Text = "";
// Load Data To catagory and CompanyList
SetupGateway setupGateway = new SetupGateway();
List <CatagoryModel> catagorylist = setupGateway.GetAllCatagory();
List <CompanyModel> companyList = setupGateway.GetAllCompany();
if (catagorylist.Count > 0)
{
var catagoryList = catagorylist.Select(x => new
{
Value = x.Id,
Text = x.Name
}).ToList();
catagoryListBox.ValueMember = "Value";
catagoryListBox.DisplayMember = "Text";
catagoryListBox.DataSource = catagoryList;
catagoryListBox.SelectedValue = 0;
catagoryListBox.SelectedText = "--Select Category--";
}
else
{
catagoryListBox.SelectedValue = 0;
catagoryListBox.Text = "";
catagoryListBox.SelectedText = "--No Category--";
}
if (companyList.Count > 0)
{
var companylist = companyList.Select(x => new
{
Value = x.Id,
Text = x.Name
}).ToList();
companyListBox.ValueMember = "Value";
companyListBox.DisplayMember = "Text";
companyListBox.DataSource = companylist;
companyListBox.SelectedValue = 0;
companyListBox.SelectedText = "--Select Company--";
}
else
{
companyListBox.SelectedValue = 0;
companyListBox.Text = "";
companyListBox.SelectedText = "--No Company--";
}
}
public void LoadCatagoryAndCompany()
{
// Load Data To catagory and CompanyList
SetupGateway setupGateway = new SetupGateway();
List<CatagoryModel> catagorylist = setupGateway.GetAllCatagory();
List<CompanyModel> companyList = setupGateway.GetAllCompany();
if (catagorylist.Count > 0)
{
var catagoryList = catagorylist.Select(x => new
{
Value = x.Id,
Text = x.Name
}).ToList();
catagoryListBox.ValueMember = "Value";
catagoryListBox.DisplayMember = "Text";
catagoryListBox.DataSource = catagoryList;
catagoryListBox.SelectedValue = 0;
catagoryListBox.SelectedText = "--Select Category--";
}
else
{
catagoryListBox.SelectedValue = 0;
catagoryListBox.Text = "";
catagoryListBox.SelectedText = "--No Category--";
}
if (companyList.Count > 0)
{
var companylist = companyList.Select(x => new
{
Value = x.Id,
Text = x.Name
}).ToList();
companyListBox.ValueMember = "Value";
companyListBox.DisplayMember = "Text";
companyListBox.DataSource = companylist;
companyListBox.SelectedValue = 0;
companyListBox.SelectedText = "--Select Company--";
}
else
{
companyListBox.SelectedValue = 0;
companyListBox.Text = "";
companyListBox.SelectedText = "--No Company--";
}
}
private void companyDeleteButton_Click(object sender, EventArgs e)
{
if (companyIdHidden.Text.Trim() != String.Empty && Ch.IsMatch(companyTextBox.Text.Trim()))
{
if (MessageBox.Show("Are sure to delete this?", "Confirm?", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
SetupGateway setupGateway = new SetupGateway();
string Id = companyIdHidden.Text.Trim();
int rowAffect = setupGateway.DeleteCompany(Id);
if (rowAffect > 0)
{
cMessageBox.Success("Company Deleted");
CompanySetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Failed to Delete");
}
}
}
}
private void catagoryDeleteButton_Click(object sender, EventArgs e)
{
SetupGateway setupGateway = new SetupGateway();
if (idhiddenLabel.Text.Trim() != String.Empty && catagoryTextBox.Text.Trim() != String.Empty)
{
if (cMessageBox.Quiestion("Are you sure to delete this?"))
{
string id = idhiddenLabel.Text.Trim();
int rowAffect = setupGateway.DeleteCatagory(id);
if (rowAffect > 0)
{
cMessageBox.Success("Category Deleted");
CatagorySetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Failed To Delete Category");
CatagorySetup_Load(sender, e);
}
}
}
}
private void StockOut_Load(object sender, EventArgs e)
{
listofStockOut.Clear();
stockOutCard.Rows.Clear();
// Text Box
catagoryListBox.Enabled = true;
companyListBox.Enabled = true;
ItemListBox.DataSource = null;
ItemListBox.Enabled = true;
discountPercentTextBox.Enabled = true;
discountPriceTexBox.Enabled = true;
vatPercentTextBox.Enabled = true;
outQuantityTextBox.Enabled = true;
stockOutCard.Enabled = true;
modelBox.Enabled = true;
modelBox.Text = "N/A";
priceTextBox.Text = "";
outTotalPriceTextBox.Text = "";
availAbleQuatityTextBox.Text = "";
outQuantityTextBox.Text = "";
discountPercentTextBox.Text = "";
discountPriceTexBox.Text = "";
vatPercentTextBox.Text = "";
vatPriceTextBox.Text = "";
netBillTexBox.Text = "";
cardTitle.Text = "";
// Customer name and label fileds
mnumberBox.Visible = false;
customerNameBox.Visible = false;
addressTextBox.Visible = false;
nameLabel.Visible = false;
addLabel.Visible = false;
numberLabel.Visible = false;
// Button for actioins
saleButton.Enabled = true;
saleButton.Visible = false;
lostButton.Visible = false;
damageButton.Visible = false;
okButton.Visible = false;
cancelButton.Visible = false;
addCardButton.Enabled = true;
// Load Data To catagory and CompanyList
SetupGateway setupGateway = new SetupGateway();
List <CatagoryModel> catagorylist = setupGateway.GetAllCatagory();
List <CompanyModel> companyList = setupGateway.GetAllCompany();
if (catagorylist.Count > 0)
{
var catagoryList = catagorylist.Select(x => new
{
Value = x.Id,
Text = x.Name
}).ToList();
catagoryListBox.ValueMember = "Value";
catagoryListBox.DisplayMember = "Text";
catagoryListBox.DataSource = catagoryList;
catagoryListBox.SelectedValue = 0;
catagoryListBox.SelectedText = "--Select Category--";
}
else
{
catagoryListBox.SelectedValue = 0;
catagoryListBox.Text = "";
catagoryListBox.SelectedText = "--No Category Found--";
}
if (companyList.Count > 0)
{
var companylist = companyList.Select(x => new
{
Value = x.Id,
Text = x.Name
}).ToList();
companyListBox.ValueMember = "Value";
companyListBox.DisplayMember = "Text";
companyListBox.DataSource = companylist;
companyListBox.SelectedValue = 0;
companyListBox.SelectedText = "--Select Company--";
}
else
{
companyListBox.SelectedValue = 0;
companyListBox.Text = "";
companyListBox.SelectedText = "--No Company Found--";
}
}
