private void cmdNew_Click(object sender, EventArgs e)
{
IsAdd = true;
IsEdit = false;
StateCode = GlobalFunction.GetUniqueCode("StateMaster");
StateName = "";
ProcessInterface();
}
private void btnAdd_Click(object sender, EventArgs e)
{
IsAdd = true;
IsEdit = false;
ClearControl();
ControlStatus(false);
txtTrasactionID.Text = GlobalFunction.GetUniqueCode("SaleMaster");
}
private void cmdNew_Click(object sender, EventArgs e)
{
string meeintNo = GlobalFunction.GetUniqueCode("ServiceMaster");
if (meeintNo != "-1")
{
IsAdd = true;
IsEdit = false;
ClearControl();
ControlStatus(false);
txtServiceId.Text = meeintNo;
dtpServiceDate.Value = DateTime.Now.Date;
}
else
{
MessageBox.Show("Invalid Service ID. " + meeintNo);
}
}
private void Save()
{
string[] para;
object[] values;
string str1;
List <Transaction> transList = new List <Transaction>();
object obj;
try
{
if (IsAdd)
{
DialogResult dr = MessageBox.Show("Do You Want to Save Data ?", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
CityCode = GlobalFunction.GetUniqueCode("CityMaster");
/*Master Table**/
//str1 = "INSERT INTO ShareMaster(ShareHolderName,Address,PhoneNo,IsActive,CreatedOn) VALUES (@ShareHolderName,@Address,@PhoneNo,@IsActive,@CreatedOn)";
str1 = "INSERT INTO CityMaster(CityCode, CityName, StateCode,CreatedOn) VALUES (@CityCode, @CityName,@StateCode, @CreatedOn)";
para = new string[] { "@CityCode", "@CityName", "@StateCode", "@CreatedOn" };
values = new object[] { CityCode, CityName, _statecode, GlobalFunction.GetDateTimeWithoutMiliSecond(System.DateTime.Now) };
transList.Add(new Transaction(str1, para, values));
// UPdate counter
str1 = "Update UniqueCodeMaster set CurrentNo=CurrentNo + IncrementBy where TableName='CityMaster'";
para = new string[] { };
values = new object[] { };
transList.Add(new Transaction(str1, para, values));
obj = DBService.ExecuteTransaction(transList);
if (obj != null)
{
IsEdit = false;
//MessageBox.Show("Record saved succesfully");
}
else
{
MessageBox.Show("Error Occurs", "ERROR");
}
}
}
/******************************EDIT*****************************************/
else if (IsEdit)
{
DialogResult dr = MessageBox.Show("Do You Want to Update '" + txtCityCode.Text + "'", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
str1 = "Update CityMaster set CityName=@CityName, StateCode=@StateCode, LastModify=@LastModify Where CityCode = @CityCode";
para = new string[] { "@CityName", "@StateCode", "@LastModify", "@CityCode" };
values = new object[] { CityName, _statecode, GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now), CityCode };
//oleParam = new OleDbParameter[]
// {
// new OleDbParameter("@ShareHolderName",GetProperName(txtName.Text)),
// new OleDbParameter("@Address",txtAddress.Text.Trim()),
// new OleDbParameter("@PhoneNo",txtPhone.Text.Trim()),
// new OleDbParameter("@IsActive", 1),
// new OleDbParameter("@UpdatedOn",DateTime.Now.Date),
// new OleDbParameter("@ID",ID)
// };
obj = DBService.ExecuteNonQuerry(str1, para, values);
if (obj != null)
{
IsEdit = false;
//MessageBox.Show("Share Hoder is Updated succesfully");
//ControlStatus(true);
//DispayData();
//DispayData2();
}
else
{
MessageBox.Show("Error Occurs", "ERROR");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Save()
{
string querry = "";
string[] para;
object[] values;
List <Transaction> transList = new List <Transaction>();
string str1;
object obj;
int rowCount;
double totalAmount = 0.0;
try
{
if (IsAdd)
{
DialogResult dr = MessageBox.Show("Do you want to save?", "Save", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
//Get Unique ID
txtTrasactionID.Text = GlobalFunction.GetUniqueCode("SaleMaster");
str1 = "Insert into SaleMaster (TransactionID, SaleDate, CustomerName, Remarks, TotalAmount, CreatedOn) values (@TransactionID, @SaleDate, @CustomerName, @Remarks, @TotalAmount, @CreatedOn)";
para = new string[] { "@TransactionID", "@SaleDate", "@CustomerName", "@Remarks", "@TotalAmount", "@CreatedOn" };
values = new object[] { txtTrasactionID.Text.Trim(), GlobalFunction.GetDateTimeWithoutMiliSecond(dtpSaleDate.Value), txtCustomerName.Text, txtRemarks.Text.Trim(), Convert.ToDouble(txtTotalAmount.Text), GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now) };
transList.Add(new Transaction(str1, para, values));
//Save details
rowCount = dgvMain.RowCount;
for (int rowIndex = 0; rowIndex < rowCount; rowIndex++)
{
str1 = "Insert into SaleMasterDetails (TransactionID, ItemCode, Rate,Quantity, Amount, DiscountPerc, Discount, TotalAmount) values (@TransactionID, @ItemCode, @Rate,@Quantity, @Amount, @DiscountPerc, @Discount, @TotalAmount)";
para = new string[] { "@TransactionID", "@ItemCode", "@Rate", "@Quantity", "@Amount", "@DiscountPerc", "@Discount", "@TotalAmount" };
values = new object[] { txtTrasactionID.Text.Trim(), Convert.ToString(dgvMain.Rows[rowIndex].Cells[Code].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[Rate].Value), Convert.ToInt32(dgvMain.Rows[rowIndex].Cells[Quantity].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[Amount].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[DiscountPercentage].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[Discount].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[TotalAmount].Value) };
transList.Add(new Transaction(str1, para, values));
}
// UPdate counter
str1 = "Update UniqueCodeMaster set CurrentNo=CurrentNo + IncrementBy where TableName='SaleMaster'";
para = new string[] { };
values = new object[] { };
transList.Add(new Transaction(str1, para, values));
obj = DBService.ExecuteTransaction(transList);
if (obj != null)
{
IsAdd = false;
MessageBox.Show("Data is saved succesfully");
ControlStatus(true);
DisplayData(txtTrasactionID.Text.Trim());
}
else
{
MessageBox.Show("Error Occurs", "ERROR");
}
}
}
/******************************EDIT*****************************************/
else if (IsEdit)
{
DialogResult dr = MessageBox.Show("Do you want to update?", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
str1 = "Update SaleMaster set SaleDate=@SaleDate, CustomerName=@CustomerName, Remarks=@Remarks, TotalAmount=@TotalAmount, LastModify=@LastModify Where TransactionID=@TransactionID";
para = new string[] { "@SaleDate", "@CustomerName", "@Remarks", "@TotalAmount", "@LastModify", "@TransactionID" };
values = new object[] { GlobalFunction.GetDateTimeWithoutMiliSecond(dtpSaleDate.Value), txtCustomerName.Text, txtRemarks.Text.Trim(), Convert.ToDouble(txtTotalAmount.Text), GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now), txtTrasactionID.Text.Trim() };
transList.Add(new Transaction(str1, para, values));
str1 = "Delete * from SaleMasterDetails where TransactionID=@TransactionID";
para = new string[] { "@TransactionID" };
values = new object[] { txtTrasactionID.Text.Trim() };
transList.Add(new Transaction(str1, para, values));
//Save details
rowCount = dgvMain.RowCount;
for (int rowIndex = 0; rowIndex < rowCount; rowIndex++)
{
str1 = "Insert into SaleMasterDetails (TransactionID, ItemCode, Rate,Quantity, Amount, DiscountPerc, Discount, TotalAmount) values (@TransactionID, @ItemCode, @Rate,@Quantity, @Amount, @DiscountPerc, @Discount, @TotalAmount)";
para = new string[] { "@TransactionID", "@ItemCode", "@Rate", "@Quantity", "@Amount", "@DiscountPerc", "@Discount", "@TotalAmount" };
values = new object[] { txtTrasactionID.Text.Trim(), Convert.ToString(dgvMain.Rows[rowIndex].Cells[Code].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[Rate].Value), Convert.ToInt32(dgvMain.Rows[rowIndex].Cells[Quantity].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[Amount].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[DiscountPercentage].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[Discount].Value), Convert.ToDouble(dgvMain.Rows[rowIndex].Cells[TotalAmount].Value) };
transList.Add(new Transaction(str1, para, values));
}
obj = DBService.ExecuteTransaction(transList);
if (obj != null)
{
IsEdit = false;
ControlStatus(true);
MessageBox.Show("Data is updated succesfully");
DisplayData(txtTrasactionID.Text.Trim());
}
else
{
MessageBox.Show("Error Occurs", "ERROR");
}
}
}
else
{
ControlStatus(true);
IsAdd = false;
IsEdit = false;
}
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message);
}
}
private void Save()
{
string[] para;
object[] values;
string str1;
List <Transaction> transList = new List <Transaction>();
object obj;
try
{
if (AddCleint)
{
DialogResult dr = MessageBox.Show("Do You Want to Save Data ?", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
//ClientCode = GlobalFunction.GetUniqueNo("ClientMaster", "CL", 5);
ClientCode = GlobalFunction.GetUniqueCode("ClientMaster");
/*Master Table**/
//str1 = "INSERT INTO ShareMaster(ShareHolderName,Address,PhoneNo,IsActive,CreatedOn) VALUES (@ShareHolderName,@Address,@PhoneNo,@IsActive,@CreatedOn)";
str1 = "INSERT INTO ClientMaster(ClientCode, ClientName, ContactNo, Remarks, State, IndustryType, IsActive, AddService) VALUES (@ClientCode, @ClientName, @ContactNo, @Remarks, @State, @IndustryType, @IsActive, @AddService)";
para = new string[] { "@ClientCode", "@ClientName", "@ContactNo", "@Remarks", "@State", "@IndustryType", "@IsActive", "@AddService" };
values = new object[] { ClientCode, ClientName, ContactNo, Remarks, State, IndustryType, Convert.ToBoolean(IsActive), AddService };
transList.Add(new Transaction(str1, para, values));
// UPdate counter
str1 = "Update UniqueCodeMaster set CurrentNo=CurrentNo + IncrementBy where TableName='ClientMaster'";
para = new string[] { };
values = new object[] {};
transList.Add(new Transaction(str1, para, values));
obj = DBService.ExecuteTransaction(transList);
if (obj != null)
{
AddCleint = false;
MessageBox.Show("Record saved succesfully");
}
else
{
MessageBox.Show("Error Occurs", "ERROR");
}
}
}
/******************************EDIT*****************************************/
else if (EditClient)
{
DialogResult dr = MessageBox.Show("Do You Want to Update '" + txtClientName.Text + "'", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
str1 = "Update ClientMaster set ClientName=@ClientName,ContactNo=@ContactNo,Remarks=@Remarks,State=@State,IndustryType=@IndustryType, IsActive =@IsActive, AddService = @AddService Where ClientCode = @ClientCode";
para = new string[] { "@ClientName", "@ContactNo", "@Remarks", "@State", "@IndustryType", "@IsActive", "@AddService", "@ClientCode" };
values = new object[] { ClientName, ContactNo, Remarks, State, IndustryType, Convert.ToBoolean(IsActive), AddService, ClientCode };
//oleParam = new OleDbParameter[]
// {
// new OleDbParameter("@ShareHolderName",GetProperName(txtName.Text)),
// new OleDbParameter("@Address",txtAddress.Text.Trim()),
// new OleDbParameter("@PhoneNo",txtPhone.Text.Trim()),
// new OleDbParameter("@IsActive", 1),
// new OleDbParameter("@UpdatedOn",DateTime.Now.Date),
// new OleDbParameter("@ID",ID)
// };
obj = DBService.ExecuteNonQuerry(str1, para, values);
if (obj != null)
{
EditClient = false;
//MessageBox.Show("Share Hoder is Updated succesfully");
//ControlStatus(true);
//DispayData();
//DispayData2();
}
else
{
MessageBox.Show("Error Occurs", "ERROR");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
