private void btnSave_Click(object sender, EventArgs e)
{
////SQLConfig config = new SQLConfig();
config.sqlselect = "SELECT * FROM tblcategory WHERE CategoryId=" + lblCategoryId.Text;
config.sqladd = "INSERT INTO tblcategory (CategoryId,Category,CategoryType,Unit) VALUES ('" + lblCategoryId.Text + "','" + txtcategory.Text + "','" + txtType.Text + "','" + txtUnit.Text + "')";
config.sqledit = "UPDATE tblcategory SET Category='" + txtcategory.Text + "',CategoryType='" + txtType.Text + "',Unit='" + txtUnit.Text + "' WHERE CategoryId=" + lblCategoryId.Text;
config.msgadd = "New Category has been saved in the database.";
config.msgedit = "Category has been updated in the database.";
config.SaveUpdate(config.sqlselect, config.sqladd, config.msgadd, config.sqledit, config.msgedit);
string autoStart = txtcategory.Text.Substring(0, 3) + "-" + txtType.Text.Substring(0, 3) + "-";
if (categoryid == 0)
{
config.sqladd = "INSERT INTO tblautonumber (AutoStart,AutoEnd,AutoIncrement,CategoryId) VALUES ('" + autoStart + "',1,1," + lblCategoryId.Text + ")";
config.SaveData(config.sqladd);
}
else
{
config.sqledit = "UPDATE tblautonumber SET AutoStart ='" + autoStart + "' WHERE CategoryId=" + lblCategoryId.Text;
config.SaveData(config.sqledit);
}
frmCategory_Load(sender, e);
//MessageBox.Show(txtcategory.Text.Substring(0, 3));
//MessageBox.Show(txtType.Text.Substring(0, 3));
}
private void btnSave_Click_1(object sender, EventArgs e)
{
try
{
//double total;
//DateTime today = DateTime.Now;
//total =double.Parse(txtPrice.Text) * Int32.Parse (txtQty.Text);
//pro.sqladd = "INSERT INTO tblstockin (Barcode,DateReceived,Price,ReceivedQty,SubTotal,UserId) " +
// " Values('" + txtBarcode.Text + "','" + today + "','" + txtPrice.Text + "','" + txtQty.Text + "','" + total + "',1)";
//pro.SaveData(pro.sqladd);
pro.sqlselect = "SELECT * FROM tblproduct WHERE ProductId='" + lblProductId.Text + "'";
pro.sqladd = "INSERT INTO tblproduct (ProductId,Barcode,ProductName,Description,OriginalPrice,MarkupPrice,ProductQty,CategoryId) " +
" VALUES ('" + lblProductId.Text + "','" + txtBarcode.Text + "','" + txtProduct.Text + "','" + txtDescription.Text + "','" + txtPrice.Text + "','" + txtMarkupPrice.Text + "',0," + cboCategory.SelectedValue + ")";
pro.sqledit = "UPDATE tblproduct Set ProductId='" + lblProductId.Text +
"',Barcode='" + txtBarcode.Text +
"',ProductName='" + txtProduct.Text +
"',Description='" + txtDescription.Text +
"',OriginalPrice='" + txtPrice.Text +
"',MarkupPrice='" + txtMarkupPrice.Text +
"',CategoryId=" + cboCategory.SelectedValue +
" WHERE ProductId = '" + lblProductId.Text + "'";
pro.msgadd = "New Product has been saved in the database.";
pro.msgedit = "Product has been updated in the database.";
pro.SaveUpdate(pro.sqlselect, pro.sqladd, pro.msgadd, pro.sqledit, pro.msgedit);
if (pro.msg == "New Product has been saved in the database.")
{
pro.UpdateProductAutonumber(cboCategory);
pro.msg = "";
}
frmProduct_Load(sender, e);
}
catch (Exception ex)
{
}
}
private void btnSave_Click(object sender, EventArgs e)
{
user.sqlselect = "SELECT * FROM tbluser WHERE UserId =" + lblUserId.Text;
user.sqladd = "INSERT INTO tbluser (UserId,Fullname,User_name,Pass,UserRole) VALUES " +
" (" + lblUserId.Text + ",'" + txtName.Text + "','" + txtUsername.Text + "','" + txtPassword.Text + "','" + cboRole.Text + "')";
user.msgadd = "New User has been saved in the database.";
user.sqledit = "UPDATE tbluser SET Fullname='" + txtName.Text +
"',User_name='" + txtUsername.Text +
"',Pass='******',UserRole='" + cboRole.Text +
"' WHERE UserId=" + lblUserId.Text;
user.msgedit = "User has been updated in the database.";
user.SaveUpdate(user.sqlselect, user.sqladd, user.msgadd, user.sqledit, user.msgedit);
btnNew_Click(sender, e);
}