private void btn_create_Click(object sender, EventArgs e)
{
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
bool isError = false;
string itemId = txt_itemID.Text;
string itemCode = txt_itemCode.Text;
string itemName = txt_itemName.Text;
string altName = txt_altName.Text;
string itemType = (dropDown_itemType.SelectedIndex != -1) ? dropDown_itemType.SelectedItem.ToString() : string.Empty;
string stockUnit = (dropDown_stockUnit.SelectedIndex != -1) ? dropDown_stockUnit.SelectedItem.ToString() : string.Empty;
string shopUnit = (dropDown_shopUnit.SelectedIndex != -1) ? dropDown_shopUnit.SelectedItem.ToString() : string.Empty;
var dataList = new List <Tuple <string, string> >();
dataList.Add(new Tuple <string, string>("itemCode", itemCode));
dataList.Add(new Tuple <string, string>("itemName", itemName));
dataList.Add(new Tuple <string, string>("altName", altName));
dataList.Add(new Tuple <string, string>("itemType", itemType));
dataList.Add(new Tuple <string, string>("stockUnitId", itemType));
dataList.Add(new Tuple <string, string>("shopUnitId", itemType));
isError = checkInsertedItemData(dataList);
if (!isError)
{
//insert data to db
CREATEITEM._itemId = Convert.ToInt32(itemId);
CREATEITEM._itemCode = itemCode;
CREATEITEM._itemName = itemName;
CREATEITEM._altName = altName;
CREATEITEM._itemTypeId = Convert.ToInt32(dropDown_itemType.SelectedValue);
CREATEITEM._stockUnitId = Convert.ToInt32(dropDown_stockUnit.SelectedValue);
CREATEITEM._shopUnitId = Convert.ToInt32(dropDown_shopUnit.SelectedValue);
if (MANAGEDB.insertData_item(CREATEITEM))
{
COM_MESSAGE.successfullMessage("Successfully created the Item ");
COMM_METHODS.clearAllText(this);
filldropDownLists();
txt_itemID.Text = MANAGEDB.getMaxItemId().ToString();
}
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
private void btn_create_Click(object sender, EventArgs e)
{
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
bool isError = false;
string dealerId = txt_dealerID.Text;
string dealerName = txt_dealerName.Text;
string companyName = txt_companyName.Text;
string address = txt_address.Text;
string phoneNo = txt_phoneNo.Text;
string mobile = txt_mobile.Text;
var dataList = new List <Tuple <string, string> >();
dataList.Add(new Tuple <string, string>("dealerName", dealerName));
dataList.Add(new Tuple <string, string>("companyName", companyName));
dataList.Add(new Tuple <string, string>("phoneNo", phoneNo));
dataList.Add(new Tuple <string, string>("mobile", mobile));
isError = checkInsertedDealerData(dataList);
if (!isError)
{
//insert data to db
ADD_DEALER._dealerId = Convert.ToInt32(dealerId);
ADD_DEALER._dealerName = dealerName;
ADD_DEALER._companyName = companyName;
ADD_DEALER._address = address;
ADD_DEALER._phoneNo = phoneNo;
ADD_DEALER._mobile = mobile;
if (MANAGEDB.insertData_dealer(ADD_DEALER))
{
COM_MESSAGE.successfullMessage("Successfully created the Item ");
COMM_METHODS.clearAllText(this);
txt_dealerID.Text = MANAGEDB.getMaxDealerId().ToString();
}
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
private void btn_create_Click(object sender, EventArgs e)
{
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
bool isError = false;
string assetId = txt_assetId.Text;
string assetName = txt_assetName.Text;
string value = txt_value.Text;
string description = txt_description.Text;
string quantity = txt_quantity.Text;
string totalValue = txt_total.Text;
var dataList = new List <Tuple <string, string> >();
dataList.Add(new Tuple <string, string>("assetName", assetName));
dataList.Add(new Tuple <string, string>("value", value));
dataList.Add(new Tuple <string, string>("quantity", quantity));
isError = checkInsertedAssetData(dataList);
if (!isError)
{
//insert data to db
ADD_ASSET._assetId = Convert.ToInt32(assetId);
ADD_ASSET._assetName = assetName;
ADD_ASSET._value = (!string.IsNullOrEmpty(value)) ? Convert.ToDouble(value) : 0;
ADD_ASSET._descrption = description;
ADD_ASSET._quantity = (!string.IsNullOrEmpty(quantity)) ? Convert.ToDouble(quantity) : 0;
ADD_ASSET._totalValue = (!string.IsNullOrEmpty(totalValue)) ? Convert.ToDouble(totalValue) : 0;
if (MANAGEDB.insertData_asset(ADD_ASSET))
{
COM_MESSAGE.successfullMessage("Successfully Insert the Asset ");
COMM_METHODS.clearAllText(this);
txt_assetId.Text = MANAGEDB.getMaxAssetId().ToString();
}
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
private void btn_add_Click(object sender, EventArgs e)
{
bool isError = false;
int itemTypeIdId = Convert.ToInt16(txt_itemTypeID.Text);
string itemType = txt_itemType.Text;
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
//validate item Type name
if (VALIDATION.isEmptyTextBox(itemType))
{
COM_MESSAGE.validationMessage("Item Type Cannot be Empty !!!");
isError = true;
}
else
{
if (!VALIDATION.isLetterAndNumberOnly(itemType))
{
COM_MESSAGE.validationMessage("Item Type should contains only Letters and Numbers !!!");
isError = true;
}
}
if (!isError)
{
//insert data to tbl_itemtype
if (MANAGEDB.insertData_itemType(itemTypeIdId, itemType))
{
IS_SUCCESS_MESSAGE = true;
COM_MESSAGE.successfullMessage("Successfully created the Item Type !!!");
clearAllText(this);
txt_itemTypeID.Text = MANAGEDB.getMaxItemTypeID().ToString();
txt_itemType.Focus();
}
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
//private void dateTime_stockEntry_ValueChanged(object sender, EventArgs e)
//{
// txt_stockEntryDate.Text = dateTime_stockEntry.Value.Date.ToString("yyyy/MM/dd");
//}
//private void dateTime_expire_ValueChanged(object sender, EventArgs e)
//{
// txt_expireDate.Text = dateTime_expire.Value.Date.ToString("yyyy/MM/dd");
//}
private void btn_add_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
bool isError = false;
var dataList = new List <Tuple <string, string> >();
dataList.Add(new Tuple <string, string>("quantity", txt_quantity.Text));
dataList.Add(new Tuple <string, string>("buyingUnitPrice", txt_buyUnitPrice.Text));
dataList.Add(new Tuple <string, string>("sellingUnitPrice", txt_sellUnitPrice.Text));
dataList.Add(new Tuple <string, string>("priceAfterDiscount", txt_sellUnitPrice.Text));
isError = checkInsertedStockEntry(dataList);
if (!isError)
{
//insert data to db
createStockData();
if (MANAGEDB.insertData_stockEntry(STOCKDATA))
{
COM_MESSAGE.successfullMessage("Successfully created the Stock Entry ");
COMM_METHODS.clearAllText(this);
setStockEntryId();
dateTime_stockEntry.Value = DateTime.Today;
fillGrid();
txt_itemCode.Focus();
}
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
Cursor.Current = Cursors.Default;
}
private void grd_editUnits_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
int unitId = 0;
BLL.ClsUnitData unitData = new BLL.ClsUnitData();
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
unitId = Convert.ToInt32(senderGrid.SelectedCells[e.ColumnIndex].Value);
unitData = MANAGEDB.getSingleUnitData(unitId);
FrmAddUnits frmAddUnits = new FrmAddUnits(unitData, USERNAME);
frmAddUnits.WindowState = FormWindowState.Normal;
frmAddUnits.ShowDialog();
grd_editUnits.DataSource = MANAGEDB.getUnitDetails();
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
private void grd_editRole_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
int roleId = 0;
BLL.clsUserRoleData roledata = new BLL.clsUserRoleData();
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
roleId = Convert.ToInt16(senderGrid.SelectedCells[e.ColumnIndex - 1].Value);
roledata = MANAGEDB.getSingleRoleData(roleId);
FrmAddUserRole addRole = new FrmAddUserRole(roledata, USERNAME);
addRole.WindowState = FormWindowState.Normal;
addRole.ShowDialog();
grd_editRole.DataSource = MANAGEDB.getUserRoleDetails();
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
private void grd_editStockEntry_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
long stockEctryId = 0;
BLL.ClsStockData stockData = new BLL.ClsStockData();
try
{
//check permission for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
stockEctryId = Convert.ToInt64(senderGrid.SelectedCells[e.ColumnIndex].Value);
stockData = MANAGEDB.getSingleStockDetail(stockEctryId);
FrmAdjustStock frmUser = new FrmAdjustStock(stockData, USERNAME);
frmUser.WindowState = FormWindowState.Normal;
frmUser.ShowDialog();
fillGrid(SEARCH);
//grd_editStockEntry.DataSource = MANAGEDB.getStockDetails(SEARCHTYPE);
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
private void btn_create_Click(object sender, EventArgs e)
{
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
bool isError = false;
string unitId = txt_unitId.Text;
string description = txt_description.Text;
string symbol = txt_symbol.Text;
var dataList = new List <Tuple <string, string> >();
dataList.Add(new Tuple <string, string>("description", description));
dataList.Add(new Tuple <string, string>("symbol", symbol));
isError = checkInsertedAssetData(dataList);
if (!isError)
{
//insert data to db
ADD_UNIT._unitId = Convert.ToInt32(unitId);
ADD_UNIT._description = description;
ADD_UNIT._symbol = symbol;
if (MANAGEDB.insertData_unit(ADD_UNIT))
{
COM_MESSAGE.successfullMessage("Successfully Insert the Unit ");
COMM_METHODS.clearAllText(this);
txt_unitId.Text = MANAGEDB.getMaxUnitId().ToString();
}
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
private void btn_add_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
bool isError = false;
var dataList = new List <Tuple <string, string> >();
dataList.Add(new Tuple <string, string>("comment", txt_comment.Text));
dataList.Add(new Tuple <string, string>("destination", txt_destinationId.Text));
dataList.Add(new Tuple <string, string>("stockEntryId", txt_stockEntryId.Text));
isError = checkInsertedReleaseEntry(dataList);
if (!isError)
{
//insert to DataGrid
createDataRow();
txt_billAmt.Text = (Convert.ToDouble(txt_billAmt.Text) + Convert.ToDouble(txt_total.Text)).ToString();
clearAfterAdd();
txt_itemCode.Focus();
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
Cursor.Current = Cursors.Default;
}
private void btn_add_Click(object sender, EventArgs e)
{
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
bool isError = false;
string taxId = txt_taxId.Text;
string symbol = txt_symbol.Text;
string description = txt_description.Text;
string taxPercentage = txt_taxPercentage.Text;
DateTime from = DateTime.MinValue.Date;
DateTime to = DateTime.MinValue.Date;
var dataList = new List <Tuple <string, string> >();
dataList.Add(new Tuple <string, string>("symbol", symbol));
dataList.Add(new Tuple <string, string>("description", description));
dataList.Add(new Tuple <string, string>("taxPercentage", taxPercentage));
isError = checkInsertedTaxData(dataList);
if (chk_timePeriod.Checked)
{
from = dateTime_from.Value.Date;
to = dateTime_to.Value.Date;
if (from > to)
{
isError = true;
COM_MESSAGE.validationMessage("From Date cannot be greater than To Date !!!");
}
}
if (!isError)
{
//insert data to db
ADD_TAX._taxId = Convert.ToInt32(taxId);
ADD_TAX._symbol = symbol;
ADD_TAX._description = description;
ADD_TAX._taxPercentage = Convert.ToDouble(taxPercentage);
ADD_TAX._effectFrom = from;
ADD_TAX._effectTo = to;
if (MANAGEDB.insertData_tax(ADD_TAX))
{
COM_MESSAGE.successfullMessage("Successfully Insert the Tax ");
COMM_METHODS.clearAllText(this);
txt_taxId.Text = MANAGEDB.getMaxTaxId().ToString();
}
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
private void btn_save_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
List <BLL.clsUserPermission> data = new List <BLL.clsUserPermission>();
DataTable dt = new DataTable();
bool isOK = false;
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
foreach (DataGridViewColumn col in grd_userPermission.Columns)
{
dt.Columns.Add(col.HeaderText);
}
foreach (DataGridViewRow row in grd_userPermission.Rows)
{
DataRow dRow = dt.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
if (cell.Value == null)
{
dRow[cell.ColumnIndex] = 0;
}
else if (cell.Value is Boolean)
{
if (Convert.ToBoolean(cell.Value))
{
dRow[cell.ColumnIndex] = 1;
}
else
{
dRow[cell.ColumnIndex] = 0;
}
}
else
{
dRow[cell.ColumnIndex] = cell.Value;
}
}
dt.Rows.Add(dRow);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
CheckBox chk_view = dt.Rows[i]["View Permission"] as CheckBox;
CheckBox chk_act = dt.Rows[i]["Action Permission"] as CheckBox;
data.Add(new BLL.clsUserPermission()
{
_userRoleName = dt.Rows[i]["userRoleName"].ToString(),
_roleId = Convert.ToInt32(dt.Rows[i]["userRoleId"]),
_formId = Convert.ToInt32(dt.Rows[i]["formId"]),
_formName = dt.Rows[i]["formName"].ToString(),
_project = dt.Rows[i]["project"].ToString(),
_view = Convert.ToInt16(dt.Rows[i]["View Permission"]),
_action = Convert.ToInt16(dt.Rows[i]["Action Permission"])
});
}
//insert to db
isOK = MANAGEDB.insert_userPermission(data);
if (isOK)
{
COM_MESSAGE.successfullMessage("Successfully Updated user Permissions !!!");
this.Close();
}
else
{
COM_MESSAGE.errorMessage("user Permissions not updated successfully !!!", "EEROR");
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
Cursor.Current = Cursors.Default;
}
private void btn_create_Click(object sender, EventArgs e)
{
try
{
//check for do action
if (COMM_METHODS.checkActPermission(this.Name, USERNAME))
{
bool isError = false;
string userName = txt_userName.Text;
string firstName = txt_firstName.Text;
string lastName = txt_lastName.Text;
string idNumber = txt_nic.Text;
string email = txt_email.Text;
string userRole = (dropDown_userRole.SelectedIndex != -1) ? dropDown_userRole.SelectedItem.ToString() : string.Empty;
string phoneNo = txt_phoneNumber.Text;
var dataList = new List <Tuple <string, string> >();
dataList.Add(new Tuple <string, string>("userName", userName));
dataList.Add(new Tuple <string, string>("firstName", firstName));
dataList.Add(new Tuple <string, string>("lastName", lastName));
dataList.Add(new Tuple <string, string>("idNumber", idNumber));
dataList.Add(new Tuple <string, string>("email", email));
dataList.Add(new Tuple <string, string>("userRole", userRole));
dataList.Add(new Tuple <string, string>("phoneNo", phoneNo));
isError = checkInsertedUserData(dataList);
if (!isError)
{
//insert data to db
CREATEUSER._userId = Convert.ToInt16(txt_userID.Text);
CREATEUSER._userName = userName;
CREATEUSER._firstName = firstName;
CREATEUSER._lastName = lastName;
CREATEUSER._dob = Convert.ToDateTime(txt_dob.Text);
CREATEUSER._idNumber = idNumber;
CREATEUSER._address = txt_address.Text;
CREATEUSER._email = email;
CREATEUSER._userRole = userRole;
CREATEUSER._roleId = Convert.ToInt16(dropDown_userRole.SelectedValue);
CREATEUSER._phoneNo = phoneNo;
//insert to tbl_userDetail and tbl_login
if (MANAGEDB.InsertData_userDetail(CREATEUSER))
{
COM_MESSAGE.successfullMessage("Successfully created the user ");
COMM_METHODS.clearAllText(this);
dropDown_userRole.SelectedIndex = -1;
txt_userID.Text = MANAGEDB.getMaxUserID().ToString();
}
}
}
else
{
COM_MESSAGE.permissionMessage("Sorry You dont have permission to do action !!!");
}
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}