private void FindExisitingTransfer(string ReqNo)
{
if (T_staffUsageDL.ExistingT_staffUsage(ReqNo.Trim()))
{
formMode = 3;
//clear datagrid
dtx.Clear();
dataGridView1.Refresh();
//clear error fields
errorProvider1.Clear();
t_staffUsage cat = new t_staffUsage();
cat.no = ReqNo.Trim();
T_staffUsageDL dl = new T_staffUsageDL();
cat = dl.Selectt_staffUsage(cat);
//set the process message and mode to edit mode
if (cat.isProcessed == false)
{
lbl_processes.Visible = false;
performButtons(xEnums.PerformanceType.Edit);
}
else
{
lbl_processes.Visible = true;
}
//load and disable the data fields
//txt_destinationLocId.Text = cat.destinationLocId.Trim();
txt_sourceLocId.Text = cat.locationId.Trim();
//txt_supplierId.Text = cat.supplierId.Trim();
txt_remarks.Text = cat.remarks;
//dte_date.Value = cat.process_date.Value;
textareaFunctions(false);
t_staffUsage_detail req = new t_staffUsage_detail();
req.staffUsageNo = ReqNo.Trim();
T_staffUsage_detailDL tdl = new T_staffUsage_detailDL();
List <t_staffUsage_detail> requests = new List <t_staffUsage_detail>();
requests = tdl.SelectT_staffUsage_detailMulti(req);
foreach (t_staffUsage_detail det in requests)
{
commonFunctions.AddRow(dtx, det.stockCode, findExisting.FindExisitingStock(det.stockCode).Trim(), det.costPrice.ToString(), det.costPrice.ToString(), det.quantity.ToString(), det.amount.ToString());
}
txt_net.Text = commonFunctions.GetGrossAmount(dataGridView1).ToString();
txt_grossAmount.Text = commonFunctions.GetGrossAmount(dataGridView1).ToString();
txt_noOfPeaces.Text = commonFunctions.GetNoofPices(dataGridView1).ToString();
txt_noOfItems.Text = commonFunctions.GetNoofItems(dataGridView1).ToString();
}
else
{
if (formMode != 1)
{
errorProvider1.SetError(txt_no, "Wastage Number you have entered does not exists in the system.");
}
}
}
private void performButtons(xEnums.PerformanceType xenum)
{
try
{
switch (xenum)
{
case xEnums.PerformanceType.View:
if (ActiveControl.Name.Trim() == txt_no.Name.Trim())
{
int length = Convert.ToInt32(ConfigurationManager.AppSettings["StaffUSFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["StaffUSSQL"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["StaffUSField" + m + ""].ToString();
}
frmU_Search find = new frmU_Search(strSQL, strSearchField, this);
find.ShowDialog(this);
}
break;
case xEnums.PerformanceType.New:
FunctionButtonStatus(xEnums.PerformanceType.New);
formMode = 1;
txt_no.Text = commonFunctions.GetSerial(formID.Trim());
txt_no.Focus();
txt_sourceLocId.Text = commonFunctions.GlobalLocation;
txt_locationId_name.Text = findExisting.FindExisitingLoca(txt_sourceLocId.Text.Trim());
errorProvider1.Clear();
lbl_processes.Visible = false;
break;
case xEnums.PerformanceType.Edit:
FunctionButtonStatus(xEnums.PerformanceType.Edit);
formMode = 3;
//txt_VehicleID.Enabled = false;
//txt_VehicleNo.Focus();
errorProvider1.Clear();
break;
case xEnums.PerformanceType.Save:
errorProvider1.Clear();
if (formMode == 1)
{
if (!M_LocaDL.ExistingM_Loca(txt_sourceLocId.Text.Trim()))
{
errorProvider1.SetError(txt_sourceLocId, "Location does not exists on the system ");
return;
}
if (commonFunctions.GetNoofItems(dataGridView1) <= 0)
{
errorProvider1.SetError(dataGridView1, "Please enter some items to the details grid");
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
using (System.Transactions.TransactionScope transaction = new System.Transactions.TransactionScope())
{
//u_DBConnection.BeginTrans();
//save header data
t_staffUsage objt_staffUsage = new t_staffUsage();
objt_staffUsage.no = txt_no.Text.Trim();
objt_staffUsage.locationId = commonFunctions.GlobalLocation;
objt_staffUsage.date = dte_date.Value;
objt_staffUsage.refNo = txt_refNo.Text.Trim();
objt_staffUsage.remarks = txt_remarks.Text.Trim();
objt_staffUsage.noOfItems = commonFunctions.ToDecimal(txt_noOfItems.Text.Trim());
objt_staffUsage.noOfPeaces = commonFunctions.ToDecimal(txt_noOfPeaces.Text.Trim());
objt_staffUsage.grossAmount = commonFunctions.ToDecimal(txt_grossAmount.Text.Trim());
objt_staffUsage.isSaved = true;
objt_staffUsage.isProcessed = false;
objt_staffUsage.processDate = DateTime.Now;
objt_staffUsage.processUser = "";
objt_staffUsage.triggerVal = 1;
objt_staffUsage.GLUpdate = false;
T_staffUsageDL bal = new T_staffUsageDL();
bal.Savet_staffUsageSP(objt_staffUsage, 1);
//save details
foreach (DataGridViewRow drow in dataGridView1.Rows)
{
if (drow.Cells["Product Code"].Value.ToString().Trim() != null)
{
//have to implement the logic. this is only saving the data to the system
t_staffUsage_detail objt_staffUsage_detail = new t_staffUsage_detail();
objt_staffUsage_detail.staffUsageNo = txt_no.Text.Trim();
objt_staffUsage_detail.locationId = commonFunctions.GlobalLocation;
objt_staffUsage_detail.Date = dte_date.Value;
objt_staffUsage_detail.stockCode = drow.Cells["Product Code"].Value.ToString();
objt_staffUsage_detail.description = findExisting.FindExisitingProduct(drow.Cells["Product Code"].Value.ToString());
objt_staffUsage_detail.quantity = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString());
objt_staffUsage_detail.costPrice = commonFunctions.ToDecimal(drow.Cells["Cost Price"].Value.ToString());
objt_staffUsage_detail.amount = commonFunctions.ToDecimal(drow.Cells["Amount"].Value.ToString());
objt_staffUsage_detail.triggerVal = 1;
T_staffUsage_detailDL bal22 = new T_staffUsage_detailDL();
bal22.Savet_staffUsage_detailSP(objt_staffUsage_detail, 1);
}
}
//increment the serial
commonFunctions.IncrementSerial(formID);
transaction.Complete();
}
//u_DBConnection.CommitTrans();
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Save_Sucess, commonFunctions.Softwarename.Trim());
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on updating data", 1);
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
UpdateStock();
t_staffUsage objt_trnsferNote = new t_staffUsage();
objt_trnsferNote.no = txt_no.Text.Trim();
T_staffUsageDL balprocess = new T_staffUsageDL();
objt_trnsferNote = balprocess.Selectt_staffUsage(objt_trnsferNote);
objt_trnsferNote.isProcessed = true;
objt_trnsferNote.processDate = DateTime.Now;
objt_trnsferNote.processUser = commonFunctions.Loginuser;
balprocess.Savet_staffUsageSP(objt_trnsferNote, 3);
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
}
//clear data in data grid
dtx.Rows.Clear();
dataGridView1.Refresh();
//clear text fields
textareaFunctions(true);
FunctionButtonStatus(xEnums.PerformanceType.Save);
//increment the serial
txt_no.Text = commonFunctions.GetSerial(formID.Trim());
//txt_supplierId.Focus();
}
}
else if (formMode == 3)
{
t_staffUsage cat = new t_staffUsage();
cat.no = txt_no.Text.Trim();
T_staffUsageDL dl = new T_staffUsageDL();
cat = dl.Selectt_staffUsage(cat);
if (cat.isProcessed == false)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
UpdateStock();
t_staffUsage objt_trnsferNote = new t_staffUsage();
objt_trnsferNote.no = txt_no.Text.Trim();
T_staffUsageDL balprocess = new T_staffUsageDL();
objt_trnsferNote = balprocess.Selectt_staffUsage(objt_trnsferNote);
objt_trnsferNote.isProcessed = true;
objt_trnsferNote.processDate = DateTime.Now;
objt_trnsferNote.processUser = commonFunctions.Loginuser;
balprocess.Savet_staffUsageSP(objt_trnsferNote, 3);
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
//clear data in data grid
dtx.Rows.Clear();
dataGridView1.Refresh();
//clear text fields
textareaFunctions(true);
FunctionButtonStatus(xEnums.PerformanceType.Save);
txt_no.Text = commonFunctions.GetSerial(formID.Trim());
txt_code.Focus();
}
}
else
{
errorProvider1.SetError(txt_no, "Wastage number you have entered already processed.");
}
}
break;
case xEnums.PerformanceType.Cancel:
txt_no.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Default);
errorProvider1.Clear();
//clear text fields
textareaFunctions(true);
//clear Datagrid
dtx.Clear();
dataGridView1.Refresh();
//txt_supplierId.Text = "";
//txt_remarks.Text = "";
lbl_processes.Visible = false;
break;
case xEnums.PerformanceType.Print:
UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information);
break;
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog("performButtons", "frm_purchaserequest", ex.Message.ToString());
throw ex;
}
}