private void btn_edit_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
if (!Directory.Exists(pathx))
{
MessageBox.Show("Path not exists . please create path .......: \n" + pathx);
Directory.CreateDirectory(pathx);
}
DateTime dt = DateTime.Now;
string backname = BuildBackupPathWithFilename(pathx, "RIT_AT");
string strsql = @"BACKUP DATABASE RIT_AT TO DISK = '" + backname.Trim() + "';";
int x = u_DBConnection.ExecuteNonQuery(strsql);
//MessageBox.Show(x.ToString());
//BackupService bs = new BackupService(u_DBConnection.g_DBConnection.ConnectionString,@"C:\");
//bs.BackupDatabase("RIT_AT");
MessageBox.Show("Backup Complete \n" + backname.Trim());
}
catch (Exception ex) {
MessageBox.Show("Backup Failed.......: \n" + ex.Message);
}
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
if (codex.Trim() != "")
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_InvoiceHed objt_trnsferNote = new T_InvoiceHed();
objt_trnsferNote.InvID = txt_DocNo.Text.Trim();
T_InvoiceHedDL dl = new T_InvoiceHedDL();
objt_trnsferNote = dl.Selectt_InvoiceHed(objt_trnsferNote);
objt_trnsferNote.Approved = 1;
objt_trnsferNote.ApprovedDate = DateTime.Now;
objt_trnsferNote.AprrovedBy = commonFunctions.Loginuser;
dl.Savet_InvoiceHedSP(objt_trnsferNote, 3);
T_OrderTracking track = new T_OrderTracking();
track.OFNo = objt_trnsferNote.OrderFormNo.Trim();
track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.OrderNo);
track.InvApproved = 1;
track.InvApprovedDate = DateTime.Now;
track.InvApprovedUser = commonFunctions.Loginuser;
new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
getProcessedInvoices();
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
}
}
else
{
errorProvider1.SetError(dataGridView1, "Pelase select a order form from the list");
}
}
private void button3_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Del, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
if (drowSaved != null)
{
if (drowSaved.Cells[0] != null)
{
T_CNParts ss = new T_CNParts();
ss.CNno = drowSaved.Cells[0].Value.ToString();
ss.ItemCode = drowSaved.Cells[2].Value.ToString();
ss.PartCode = drowSaved.Cells[4].Value.ToString();
ss.TagNumber = drowSaved.Cells[1].Value.ToString();
ss = new T_CNPartDL().Selectt_CNPart(ss);
if (!ss.Processed.Value)
{
//MessageBox.Show(drowSaved.Cells[2].Value.ToString());
T_CNPartDL.Delete_CNPart(drowSaved.Cells[0].Value.ToString(), drowSaved.Cells[2].Value.ToString(), drowSaved.Cells[4].Value.ToString(), drowSaved.Cells[1].Value.ToString());
LoadPartSaved(txt_DocNo.Text.Trim());
}
else
{
commonFunctions.SetMDIStatusMessage("Item already processed. cannot delete now", 1);
}
}
}
}
}
private void btn_set_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
foreach (DataGridViewRow rowx in dataGridView2.Rows)
{
string strMenuRights = "";
if (Convert.ToBoolean(rowx.Cells[2].Value.ToString()) == true)
{
strMenuRights = strMenuRights + "A";
}
if (Convert.ToBoolean(rowx.Cells[3].Value.ToString()) == true)
{
strMenuRights = strMenuRights + "C";
}
if (Convert.ToBoolean(rowx.Cells[4].Value.ToString()) == true)
{
strMenuRights = strMenuRights + "M";
}
if (Convert.ToBoolean(rowx.Cells[5].Value.ToString()) == true)
{
strMenuRights = strMenuRights + "D";
}
if (Convert.ToBoolean(rowx.Cells[6].Value.ToString()) == true)
{
strMenuRights = strMenuRights + "P";
}
u_UserRights right = new u_UserRights();
new u_UserRights_DL().SaveUserRightsNEw(txt_userx.Text.Trim(), rowx.Cells[0].Value.ToString(), strMenuRights);
// MessageBox.Show(rowx.Cells[0].Value.ToString() + " - " + rowx.Cells[2].Value.ToString() + " - " + strMenuRights);
}
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Save_Sucess, commonFunctions.Softwarename.Trim());
}
}
private void button4_Click(object sender, EventArgs e)
{
if (txt_userx.Text.Trim() == "")
{
errorProvider1.SetError(txt_userx, "User code cannot be a null value.");
commonFunctions.SetMDIStatusMessage("User code cannot be a null value.", 1);
return;
}
if (!U_UserxDL.ExistingU_User(txt_userx.Text.Trim()))
{
errorProvider1.SetError(txt_userx, "User code not exists.");
commonFunctions.SetMDIStatusMessage("User code not exists.", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
U_UserxDL.DeleteAllrights(txt_userx.Text.Trim());
U_UserxDL.ApplyDefaultSec(txt_userx.Text.Trim());
LoadDataSecdetails();
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Save_Sucess, commonFunctions.Softwarename.Trim());
//ApplyDefaultSec
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on updating data", 1);
}
}
}
private void btn_save_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
T_CreditNoteHead alloc = new T_CreditNoteHead();
alloc.Dono = txt_DocNo.Text.Trim();
alloc = new T_CreditNoteHeadDL().Selectt_CreditNoteHead(alloc);
decimal cumilative = decimal.Zero;
foreach (DataGridViewRow drowx in dgsave.Rows)
{
T_CNParts part = new T_CNParts();
part.CNno = drowx.Cells[0].Value.ToString().Trim();
part.ItemCode = drowx.Cells[2].Value.ToString().Trim();
part.PartCode = drowx.Cells[4].Value.ToString().Trim();
part.TagNumber = drowx.Cells[1].Value.ToString().Trim();
part = new T_CNPartDL().Selectt_CNPart(part);
part.Processed = true;
new T_CNPartDL().Savet_CNPartSP(part, 3);
}
}
catch (Exception ex) { }
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txt_AreaCode.Text.Trim() != "" && txt_Areaname.Text.Trim() != "")
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
if (M_AreaDL.ExistingM_Area(txt_AreaCode.Text.Trim()))
{
M_Area cat = new M_Area();
cat.AreaCode = txt_AreaCode.Text.Trim();
M_AreaDL dl = new M_AreaDL();
cat = dl.Selectm_Area(cat);
txt_AreaCode.Text = cat.AreaCode.Trim();
txt_Areaname.Text = cat.Descri;
}
else
{
M_Area objm_Category = new M_Area();
objm_Category.AreaCode = txt_AreaCode.Text.Trim();
objm_Category.Descri = txt_Areaname.Text.Trim();
objm_Category.Datex = DateTime.Now;
objm_Category.Locacode = "";
objm_Category.Userx = commonFunctions.Loginuser;
objm_Category.Compcode = commonFunctions.GlobalCompany;
objm_Category.Userx = commonFunctions.Loginuser;
M_AreaDL bal = new M_AreaDL();
bal.SaveM_AreaSP(objm_Category, 1);
}
}
}
}
private void btn_hanoverdo_Click(object sender, EventArgs e)
{
//lbl_message.Text = "";
errorProvider1.Clear();
if (head.Handedover == 1)
{
errorProvider1.SetError(btn_hanoverdo, "This delivery order already handovered.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order already handovered.", 1);
return;
}
if (head.Dispatched == 0)
{
errorProvider1.SetError(btn_hanoverdo, "This delivery order is not dispatched.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order is not dispatched.", 1);
return;
}
//if (!M_VehicleDL.ExistingM_Vehicle(txt_Lorry.Text.Trim()))
//{
// errorProvider1.SetError(txt_Lorry, "Vehicle details does not exists on the system ");
// commonFunctions.SetMDIStatusMessage("Vehicle details does not exists on the system ", 1);
// return;
//}
if (!M_AgentDL.ExistingM_Agent(txt_Agent.Text.Trim()))
{
errorProvider1.SetError(txt_Agent, "Agent does not exists on the system ");
commonFunctions.SetMDIStatusMessage("Agent does not exists on the system ", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHedDL dl = new T_DIliveryHedDL();
cat = new T_DIliveryHed();
cat.DoNo = head.DONo.Trim();
cat.LocaCode = commonFunctions.GlobalLocation;
cat = new T_DIliveryHedDL().Selectt_DIliveryHed(cat, 1);
cat.Handovered = 1;
cat.HandoverDate = DateTime.Now;
cat.HandoverdUser = commonFunctions.Loginuser;
head.HandOverLorry = txt_Lorry.Text.Trim();
head.Handedover = 1;
head.HandedoverDate = DateTime.Now;
head.HandedoverUser = commonFunctions.Loginuser;
if (dl.Savet_DIliveryHedSP(cat, 3) && new T_OrderTrackingDL().Savet_OrderTrackingSP(head, 3))
{
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
getProcessedOFs();
}
}
private void dataGridView2_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (dataGridView2.SelectedRows.Count > 0)
{
try
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_New, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
LoadDataCus(e.ColumnIndex, e.RowIndex);
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on loading data", 1);
}
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
try
{
if (codex.Trim() != "")
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHed objt_trnsferNote = new T_DIliveryHed();
objt_trnsferNote.DoNo = txt_DocNo.Text.Trim();
objt_trnsferNote.LocaCode = commonFunctions.GlobalLocation;
objt_trnsferNote = new T_DIliveryHedDL().Selectt_DIliveryHed(objt_trnsferNote, 2);
objt_trnsferNote.Approved = 1;
objt_trnsferNote.ApprovedDate = DateTime.Now;
objt_trnsferNote.ApprovedUser = commonFunctions.Loginuser;
new T_DIliveryHedDL().Savet_DIliveryHedSP(objt_trnsferNote, 3);
T_OrderTracking track = new T_OrderTracking();
track.DONo = txt_DocNo.Text.Trim();
//track.OFNo = txt_DocNo.Text.Trim();
track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.DoNumber);
track.DOApproved = 1;
track.DOApprovedUser = commonFunctions.Loginuser;
track.DOApprovedDate = DateTime.Now;
new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
getProcessedDOs();
}
}
else
{
errorProvider1.SetError(dataGridView1, "Pelase select a delivery order from the list");
commonFunctions.SetMDIStatusMessage("Pelase select a delivery order from the list", 1);
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error when approving the delivery order", 1);
}
}
private void btn_inscomplete_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
try
{
//lbl_message.Text = "";
if (head.DOCreated == 1)
{
if (cat.Processed == 1)
{
errorProvider1.SetError(btn_process, "This delivery order already processed.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order already processed.", 2);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHedDL dl = new T_DIliveryHedDL();
cat.Processed = 1;
cat.ProcessedDate = DateTime.Now;
cat.ProcessedUser = commonFunctions.Loginuser;
head.DOProcessed = 1;
head.DOProcessedDate = DateTime.Now;
head.DOProcessedUser = commonFunctions.Loginuser;
if (dl.Savet_DIliveryHedSP(cat, 3) && new T_OrderTrackingDL().Savet_OrderTrackingSP(head, 3))
{
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
}
}
else
{
commonFunctions.SetMDIStatusMessage("Delivery Order not created for this order", 1);
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error", 2);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Add, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
T_CreditNoteHead alloc = new T_CreditNoteHead();
alloc.Dono = txt_DocNo.Text.Trim();
alloc = new T_CreditNoteHeadDL().Selectt_CreditNoteHead(alloc);
decimal cumilative = decimal.Zero;
foreach (DataGridViewRow drowx in dataGridView1.Rows)
{
if (commonFunctions.ToDecimal(drowx.Cells[2].Value.ToString().Trim()) != decimal.Zero)
{
if (!T_CNPartDL.ExistingT_CNPart(txt_DocNo.Text.Trim(), drow.Cells[1].Value.ToString().Trim(), drow.Cells[2].Value.ToString().Trim(), drowx.Cells[0].Value.ToString().Trim()))
{
T_CNParts part = new T_CNParts();
part.CNno = txt_DocNo.Text.Trim();
part.ItemCode = drow.Cells[2].Value.ToString().Trim();
part.PartCode = drowx.Cells[0].Value.ToString().Trim();
part.Processed = false;
part.ProcessedDate = DateTime.Now;
part.ProcessedUser = commonFunctions.Loginuser;
part.QTY = commonFunctions.ToDecimal(drowx.Cells[2].Value.ToString().Trim());
part.Saved = false;
part.TagNumber = drow.Cells[1].Value.ToString().Trim();
new T_CNPartDL().Savet_CNPartSP(part, 1);
}
}
}
LoadPartSaved(txt_DocNo.Text.Trim());
}
catch (System.Data.SqlClient.SqlException ex) {
commonFunctions.SetMDIStatusMessage("Data Already exists for selected record", 1);
}
catch (Exception ex)
{
commonFunctions.SetMDIStatusMessage("Error when adding", 1);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (0 < commonFunctions.ToDecimal(txt_qtyremain.Text.Trim()))
{
errorProvider1.SetError(txt_fullqty, "You must allocate full amount for the selected customer.");
commonFunctions.SetMDIStatusMessage("You must allocate full amount for the selected customer.", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
T_SalesAllocHead alloc = new T_SalesAllocHead();
alloc.Docno = selecteddoc;
alloc = new T_SalesAllocHeadDL().Selectt_SalesAllocHead(alloc);
decimal cumilative = decimal.Zero;
foreach (DataGridViewRow drow in dgcustomer.Rows)
{
cumilative = commonFunctions.ToDecimal(drow.Cells[2].Value.ToString());
T_SalesAllocDet objt_SalesAllocDet = new T_SalesAllocDet();
objt_SalesAllocDet.Docno = selecteddoc;
objt_SalesAllocDet.SalesMan = alloc.Salesman;
objt_SalesAllocDet.Customer = drow.Cells[0].Value.ToString();
objt_SalesAllocDet.Item = alloc.Item;
objt_SalesAllocDet.AllowedQTY = alloc.AllocQTY;
objt_SalesAllocDet.AllocQTY = commonFunctions.ToDecimal(cumilative.ToString());
objt_SalesAllocDet.DateFrom = alloc.DateFrom.Value;
objt_SalesAllocDet.Dateto = alloc.Dateto.Value;
objt_SalesAllocDet.Userx = commonFunctions.Loginuser;
objt_SalesAllocDet.Datex = DateTime.Now;
T_SalesAllocDetDL bal = new T_SalesAllocDetDL();
bal.Savet_SalesAllocDetSP(objt_SalesAllocDet, 1);
}
LoadDataSavedALLOCATIONS();
}
catch (Exception ex) { }
}
}
private void button4_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
foreach (DataGridViewRow drow in dte_cheques.Rows)
{
if (drow.Cells[0].Value.ToString().Trim() != null)
{
T_RecDet det = new T_RecDet();
det = new T_RecDetDL().Selectt_RecDet(det, drow.Cells[0].Value.ToString().Trim(), drow.Cells[1].Value.ToString().Trim());
if (det != null)
{
det.isReconsile = Convert.ToBoolean(drow.Cells[6].Value);
det.isreturned = Convert.ToBoolean(drow.Cells[7].Value);
new T_RecDetDL().Savet_RecDetSP(det, 3);
}
}
}
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
if (codex.Trim() != "")
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_OrderFormHead objt_trnsferNote = new T_OrderFormHead();
objt_trnsferNote.DocNo = txt_DocNo.Text.Trim();
objt_trnsferNote = new T_OrderFormHeadDL().Selectt_OrderFormHead(objt_trnsferNote);
objt_trnsferNote.DiscountPer = commonFunctions.ToDecimal(txt_subtotdiscper.Text.Trim());
objt_trnsferNote.TotalDisc = commonFunctions.ToDecimal(txt_TotalDisc.Text.Trim());
objt_trnsferNote.NetTotal = commonFunctions.ToDecimal(txt_NetTotal.Text.Trim());
objt_trnsferNote.Approved = 1;
objt_trnsferNote.ApprovedDate = DateTime.Now;
objt_trnsferNote.ApprovedBy = commonFunctions.Loginuser;
objt_trnsferNote.Remarks = txt_Remarks.Text.Trim();
new T_OrderFormHeadDL().Savet_OrderFormHeadSP(objt_trnsferNote, 3);
T_OrderTracking track = new T_OrderTracking();
track.OFNo = objt_trnsferNote.DocNo.Trim();
track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.OrderNo);
track.OFApproved = 1;
track.OFApprovedUser = commonFunctions.Loginuser;
track.OFApprovedDate = DateTime.Now;
new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
getProcessedOrderforms();
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
}
}
else
{
errorProvider1.SetError(dataGridView1, "Pelase select a order form from the list");
commonFunctions.SetMDIStatusMessage("Pelase select a order form from the list", 1);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
string x = dgsaved.SelectedRows[0].Cells[0].Value.ToString();
T_SalesAllocDet det = new T_SalesAllocDet();
det.Docno = x.ToString();
List <T_SalesAllocDet> dets = new List <T_SalesAllocDet>();
dets = new T_SalesAllocDetDL().SelectT_SalesAllocDetMulti(det);
foreach (T_SalesAllocDet de in dets)
{
new T_SalesAllocDetDL().Savet_SalesAllocDetSP(de, 4);
}
LoadDataSavedALLOCATIONS();
UserDefineMessages.ShowMsg1("All allocation breakdown Detleted for header allocation NO: " + x, UserDefineMessages.Msg_Information);
}
}
catch (Exception ex) { }
}
private void btn_confirmdelivery_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
if (cat.Completed == 1)
{
errorProvider1.SetError(btn_hanoverdo, "This delivery order already confirmed.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order already confirmed.", 1);
return;
}
if (cat.Handovered == 0)
{
errorProvider1.SetError(btn_hanoverdo, "This delivery order is not handovered.".ToUpper());
commonFunctions.SetMDIStatusMessage("This delivery order is not handovered.", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHedDL dl = new T_DIliveryHedDL();
cat.Completed = 1;
cat.CompletedDate = DateTime.Now;
head.Completed = 1;
head.CompletedDate = DateTime.Now;
head.CompletedUser = commonFunctions.Loginuser;
head.CompleteRemark = txt_cremarks.Text.Trim();
if (dl.Savet_DIliveryHedSP(cat, 3) && new T_OrderTrackingDL().Savet_OrderTrackingSP(head, 3))
{
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
getProcessedOFs();
}
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
try
{
if (txt_aremarks.Text.Trim() == "")
{
errorProvider1.SetError(txt_aremarks, "Audit remarks cannot be empty.");
commonFunctions.SetMDIStatusMessage("Audit remarks cannot be empty.", 1);
return;
}
if (codex.Trim() == "")
{
errorProvider1.SetError(dataGridView1, "Pelase select a delivery order from the list");
commonFunctions.SetMDIStatusMessage("Pelase select a delivery order from the list", 1);
return;
}
if (!GridPass())
{
errorProvider1.SetError(dataGridView2, "There is a variance in DO QTY and actual QTY");
commonFunctions.SetMDIStatusMessage("There is a variance in DO QTY and actual QTY", 1);
return;
}
if (!CartonChecking())
{
errorProvider1.SetError(dataGridView2, "Invalied Carton details");
commonFunctions.SetMDIStatusMessage("Invalied Carton details", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_DIliveryHed objt_trnsferNote = new T_DIliveryHed();
objt_trnsferNote.DoNo = txt_DocNo.Text.Trim();
objt_trnsferNote.LocaCode = commonFunctions.GlobalLocation;
objt_trnsferNote = new T_DIliveryHedDL().Selectt_DIliveryHed(objt_trnsferNote, 2);
objt_trnsferNote.AuditRemarks = txt_aremarks.Text.Trim();
objt_trnsferNote.ReportedProblems = txt_repproblems.Text.Trim();
objt_trnsferNote.Audited = 1;
objt_trnsferNote.AuditDate = DateTime.Now;
objt_trnsferNote.AuditUser = commonFunctions.Loginuser;
new T_DIliveryHedDL().Savet_DIliveryHedSP(objt_trnsferNote, 3);
T_OrderTracking track = new T_OrderTracking();
track.DONo = txt_DocNo.Text.Trim();
track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.DoNumber);
track.Audited = 1;
track.AuditUser = commonFunctions.Loginuser;
track.AuditDate = DateTime.Now;
new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
foreach (DataGridViewRow drow in dataGridView2.Rows)
{
if (drow.Cells[0].Value.ToString().Trim() != null)
{
T_DiliveryDet det = new T_DiliveryDet();
det.DoNo = txt_DocNo.Text.Trim();
det.Item = drow.Cells[0].Value.ToString().Trim();
det = new T_DiliveryDetDL().Selectt_DiliveryDet(det);
det.Carton = commonFunctions.ToDecimal(drow.Cells[5].Value.ToString().Trim());
det.ActualCartons = commonFunctions.ToDecimal(drow.Cells[5].Value.ToString().Trim());
det.Remarks = drow.Cells[7].Value.ToString().Trim();
det.Pass = true;
new T_DiliveryDetDL().Savet_DiliveryDetSP(det, 3);
}
}
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
getProcessedDOs();
getDetails("");
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error when approving the delivery order", 1);
}
}
private void performButtons(xEnums.PerformanceType xenum)
{
switch (xenum)
{
case xEnums.PerformanceType.View:
if (ActiveControl.Name.Trim() == txt_comcode.Name.Trim())
{
int length = Convert.ToInt32(ConfigurationManager.AppSettings["BankFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["BankSQL"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["BankField" + 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_comcode.Focus();
break;
case xEnums.PerformanceType.Edit:
FunctionButtonStatus(xEnums.PerformanceType.Edit);
formMode = 3;
txt_name.Focus();
break;
case xEnums.PerformanceType.Save:
try
{
if (formMode == 1)
{
if (M_CompanyDL.ExistingBank(txt_comcode.Text.Trim()))
{
UserDefineMessages.ShowMsg("The company code you have entered already exists!", UserDefineMessages.Msg_Warning);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_Company objbank = new M_Company();
objbank.CompCode = txt_comcode.Text.Trim();
objbank.Descr = txt_name.Text.Trim().ToUpper();
objbank.Add1 = txt_add1.Text.Trim();
objbank.Add2 = txt_add2.Text.Trim();
objbank.Add3 = txt_add3.Text.Trim();
objbank.Datex = DateTime.Now;
objbank.Emailx = txt_email.Text.Trim();
objbank.Fax = txt_fax.Text.Trim();
objbank.Tpno = txt_tp.Text.Trim();
objbank.Userx = commonFunctions.Loginuser;
M_CompanyDL bal = new M_CompanyDL();
bal.SaveBankSP(objbank, 1);
GetData();
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
}
else if (formMode == 3)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_Company objbank = new M_Company();
objbank.CompCode = txt_comcode.Text.Trim();
objbank.Descr = txt_name.Text.Trim().ToUpper();
objbank.Add1 = txt_add1.Text.Trim();
objbank.Add2 = txt_add2.Text.Trim();
objbank.Add3 = txt_add3.Text.Trim();
objbank.Datex = DateTime.Now;
objbank.Emailx = txt_email.Text.Trim();
objbank.Fax = txt_fax.Text.Trim();
objbank.Tpno = txt_tp.Text.Trim();
objbank.Userx = commonFunctions.Loginuser;
M_CompanyDL bal = new M_CompanyDL();
bal.SaveBankSP(objbank, 3);
GetData();
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
}
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on loading data", 1);
}
break;
case xEnums.PerformanceType.Cancel:
FunctionButtonStatus(xEnums.PerformanceType.Default);
break;
case xEnums.PerformanceType.Print:
UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information);
break;
}
}
private void btn_addCat_Click(object sender, EventArgs e)
{
if (txt_Codex.Text.Trim() == "")
{
errorProvider1.SetError(txt_Codex, "Please enter a customer category code !");
return;
}
if (txt_Descr.Text.Trim() == "")
{
errorProvider1.SetError(txt_Descr, "Please enter a customer category !");
return;
}
lbl_new.Hide();
try
{
if (M_CustomerCategoryDL.ExistingM_CustomerCategory(txt_Codex.Text.Trim()))
{
lbl_new.Hide();
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_CustomerCategory objm_Category = new M_CustomerCategory();
objm_Category.CusCateID = txt_Codex.Text.Trim();
objm_Category.Description = txt_Descr.Text.Trim();
objm_Category.Datex = DateTime.Now;//txt_date.Text.Trim();
objm_Category.Userx = commonFunctions.Loginuser;
new M_CustomerCategoryDL().Savem_CustomerCategorySP(objm_Category, 3);
GetData();
txt_Codex.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
}
else
{
lbl_new.Show();
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_CustomerCategory objm_Category = new M_CustomerCategory();
objm_Category.CusCateID = txt_Codex.Text.Trim();
objm_Category.Description = txt_Descr.Text.Trim();
objm_Category.Datex = DateTime.Now;//txt_date.Text.Trim();
objm_Category.Userx = commonFunctions.Loginuser;
new M_CustomerCategoryDL().Savem_CustomerCategorySP(objm_Category, 1);
GetData();
txt_Codex.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
}
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on loading data", 1);
}
}
private void button3_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
if (txtUCode.Text.Trim() == "")
{
errorProvider1.SetError(txtUCode, "User code cannot be a null value.");
commonFunctions.SetMDIStatusMessage("User code cannot be a null value.", 1);
return;
}
if (txtUCode.Text.Trim().Length < 5)
{
errorProvider1.SetError(txtUCode, "User code must be more than 6 charactors.");
commonFunctions.SetMDIStatusMessage("User code must be more than 6 charactors", 1);
return;
}
if (U_UserxDL.ExistingU_User(txtUserID.Text.Trim()))
{
errorProvider1.SetError(txtUCode, "User code already exists.");
commonFunctions.SetMDIStatusMessage("User code already exists.", 1);
return;
}
if (txtUName.Text.Trim() == "")
{
errorProvider1.SetError(txtUName, "User name cannot be a null value.");
commonFunctions.SetMDIStatusMessage("User name cannot be a null value.", 1);
return;
}
if (txtPw.Text == "")
{
errorProvider1.SetError(txtPw, "Password cannot be a null value.");
commonFunctions.SetMDIStatusMessage("Password cannot be a null value.", 1);
return;
}
if (txtPw.Text != txtRePw.Text)
{
errorProvider1.SetError(txtPw, "Password and the confirmation password must be same");
commonFunctions.SetMDIStatusMessage("Password and the confirmation password must be same.", 1);
return;
}
if (!U_UserRolexDL.ExistingU_UserRole(txtusergroup.Text.Trim()))
{
errorProvider1.SetError(txtusergroup, "User group already exists.");
commonFunctions.SetMDIStatusMessage("User group already exists.", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
//u_Userxcc obju_User = new u_Userxcc();
//obju_User.userId = txtUserID.Text.Trim();
//obju_User.userName = txtUCode.Text.Trim();
//obju_User.password = commonFunctions.CreateCheckPassword(true, txtPw.Text.Trim());
//obju_User.roleId = txtusergroup.Text.Trim();
//obju_User.userCreated = commonFunctions.Loginuser;
//obju_User.dateCreated = DateTime.Now;
//obju_User.userModified = "";
//obju_User.dateModified = DateTime.Now;
//obju_User.isActive = 1;
//obju_User.empId = "";
//obju_User.signOnTime = DateTime.Now;
//obju_User.signOnDate = DateTime.Now;
//obju_User.shiftNo = 1;
//obju_User.isSignOn = 1;
//obju_User.isSignOff = 1;
//obju_User.signOffDate = DateTime.Now;
//obju_User.signOffTime = DateTime.Now;
//obju_User.dateTimeFormat = "dd/MM/yyyy";
//obju_User.mobile = txtmobile.Text;
//obju_User.terminalID = "";
//obju_User.shiftOnLocation = commonFunctions.GlobalLocation;
//U_UserxDL bal = new U_UserxDL();
//bal.Saveu_UserSP(obju_User, 1);
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);
}
}
}
private void performButtons(xEnums.PerformanceType xenum)
{
try
{
switch (xenum)
{
case xEnums.PerformanceType.View:
if (ActiveControl.Name.Trim() == txt_reqno.Name.Trim())
{
int length = Convert.ToInt32(ConfigurationManager.AppSettings["PurreqFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["PurreqField"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["VehicleField" + 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_reqno.Text = commonFunctions.GetSerial(formID.Trim());
txt_reqno.Focus();
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 (T_purchaseRequisitionDL.ExistingT_purchaseRequisition(txt_reqno.Text.Trim()))
{
errorProvider1.SetError(txt_reqno, "Selected request No already exists on the system ");
commonFunctions.SetMDIStatusMessage("Selected request No already exists on the system ", 1);
return;
}
if (!M_LocaDL.ExistingM_Loca(txt_location.Text.Trim()))
{
errorProvider1.SetError(txt_location, "Selected location does not exists on the system ");
commonFunctions.SetMDIStatusMessage("Selected location does not exists on the system", 1);
return;
}
if (!M_SupplierDL.ExistingM_Supplier(txt_Suplier.Text.Trim()))
{
errorProvider1.SetError(txt_Suplier, "Selected supplier does not exists on the system ");
commonFunctions.SetMDIStatusMessage("Selected supplier does not exists on the system ", 1);
return;
}
if (commonFunctions.GetNoofItems(dataGridView1) <= 0)
{
errorProvider1.SetError(dataGridView1, "Please enter some items to the details grid");
commonFunctions.SetMDIStatusMessage("Please enter some items to the details grid ", 1);
return;
}
if (DateTime.Compare(dte_request.Value, dte_dilivary.Value) > -1)
{
errorProvider1.SetError(dte_dilivary, "Delivary date must be grater than request date");
commonFunctions.SetMDIStatusMessage("Delivary date must be grater than request date ", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
using (TransactionScope transaction = new TransactionScope())
{
//save header data
t_purchaseRequisition objt_purchaseRequisition = new t_purchaseRequisition();
objt_purchaseRequisition.no = txt_reqno.Text.Trim();
objt_purchaseRequisition.date = dte_request.Value;
objt_purchaseRequisition.deleveryDate = dte_dilivary.Value;
objt_purchaseRequisition.remarks = txt_remark.Text.Trim();
objt_purchaseRequisition.processDate = DateTime.Now;
objt_purchaseRequisition.processUser = "";
objt_purchaseRequisition.locationId = commonFunctions.GlobalLocation;
objt_purchaseRequisition.supplierId = txt_Suplier.Text.Trim();
objt_purchaseRequisition.noOfItems = commonFunctions.ToDecimal(txt_items.Text.Trim());
objt_purchaseRequisition.noOfPeaces = commonFunctions.ToDecimal(txt_pices.Text.Trim());
objt_purchaseRequisition.grossAmount = commonFunctions.ToDecimal(txt_gross.Text.Trim());
objt_purchaseRequisition.isSaved = true;
objt_purchaseRequisition.isProcessed = false;
objt_purchaseRequisition.triggerVal = 1;
T_purchaseRequisitionDL bal = new T_purchaseRequisitionDL();
bal.SaveT_purchaseRequisitionSP(objt_purchaseRequisition, 1);
//save details
foreach (DataGridViewRow drow in dataGridView1.Rows)
{
if (drow.Cells["Product Code"].Value.ToString().Trim() != null)
{
t_purchaseReq_detail objt_purchaseReq_detail = new t_purchaseReq_detail();
objt_purchaseReq_detail.purchaseReqNo = txt_reqno.Text.Trim();
objt_purchaseReq_detail.locationId = commonFunctions.GlobalLocation;
objt_purchaseReq_detail.ReqDate = dte_request.Value;
objt_purchaseReq_detail.deleveryDate = dte_dilivary.Value;
objt_purchaseReq_detail.productId = drow.Cells["Product Code"].Value.ToString();
objt_purchaseReq_detail.description = drow.Cells["Product Name"].Value.ToString();
objt_purchaseReq_detail.quantity = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString());
objt_purchaseReq_detail.costPrice = commonFunctions.ToDecimal(drow.Cells["Cost Price"].Value.ToString());
objt_purchaseReq_detail.amount = commonFunctions.ToDecimal(drow.Cells["Amount"].Value.ToString());
objt_purchaseReq_detail.release = 0;
objt_purchaseReq_detail.r_value = 0;
objt_purchaseReq_detail.triggerVal = 0;
T_purchaseReq_detailDL bal2 = new T_purchaseReq_detailDL();
bal2.SaveT_purchaseReq_detailSP(objt_purchaseReq_detail, 1);
}
}
//increment the serial
commonFunctions.IncrementSerial(formID);
transaction.Complete();
}
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Save_Sucess, commonFunctions.Softwarename.Trim());
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
t_purchaseRequisition objt_purchaseRequisitionxc = new t_purchaseRequisition();
objt_purchaseRequisitionxc.no = txt_reqno.Text.Trim();
T_purchaseRequisitionDL bal2 = new T_purchaseRequisitionDL();
objt_purchaseRequisitionxc = bal2.Selectt_purchaseRequisition(objt_purchaseRequisitionxc);
objt_purchaseRequisitionxc.isProcessed = true;
objt_purchaseRequisitionxc.processDate = DateTime.Now;
objt_purchaseRequisitionxc.processUser = commonFunctions.Loginuser;
bal2.SaveT_purchaseRequisitionSP(objt_purchaseRequisitionxc, 3);
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
}
//clear data in data grid
dtx.Rows.Clear();
dataGridView1.Refresh();
//clear text fields
txt_Suplier.Text = "";
txt_suppliername.Text = "";
txt_location.Text = "";
txt_locaname.Text = "";
txt_remark.Text = "";
txt_code.Text = "";
txt_cost.Text = "0.00";
txt_selling.Text = "0.00";
txt_qty.Text = "0.00";
txt_amt.Text = "0.00";
txt_reqno.Enabled = true;
txt_Suplier.Enabled = true;
txt_location.Enabled = true;
txt_remark.Enabled = true;
dataGridView1.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
//increment the serial
txt_reqno.Text = commonFunctions.GetSerial(formID.Trim());
txt_location.Focus();
}
}
else if (formMode == 3)
{
t_purchaseRequisition cat = new t_purchaseRequisition();
cat.no = txt_reqno.Text.Trim();
T_purchaseRequisitionDL dl = new T_purchaseRequisitionDL();
cat = dl.Selectt_purchaseRequisition(cat);
if (cat.isProcessed == false)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
t_purchaseRequisition objt_purchaseRequisitionxc = new t_purchaseRequisition();
objt_purchaseRequisitionxc.no = txt_reqno.Text.Trim();
T_purchaseRequisitionDL bal2 = new T_purchaseRequisitionDL();
objt_purchaseRequisitionxc = bal2.Selectt_purchaseRequisition(objt_purchaseRequisitionxc);
objt_purchaseRequisitionxc.isProcessed = true;
objt_purchaseRequisitionxc.processDate = DateTime.Now;
objt_purchaseRequisitionxc.processUser = commonFunctions.Loginuser;
bal2.SaveT_purchaseRequisitionSP(objt_purchaseRequisitionxc, 3);
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
//clear data in data grid
dtx.Rows.Clear();
dataGridView1.Refresh();
//clear text fields
txt_Suplier.Text = "";
txt_suppliername.Text = "";
txt_location.Text = "";
txt_locaname.Text = "";
txt_remark.Text = "";
txt_reqno.Enabled = true;
txt_Suplier.Enabled = true;
txt_location.Enabled = true;
txt_remark.Enabled = true;
dataGridView1.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
//increment the serial
txt_reqno.Text = commonFunctions.GetSerial(formID.Trim());
txt_location.Focus();
}
}
else
{
errorProvider1.SetError(txt_reqno, "Request Number you have entered already processed.");
commonFunctions.SetMDIStatusMessage("Request Number you have entered already processed.", 1);
}
}
break;
case xEnums.PerformanceType.Cancel:
txt_reqno.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Default);
errorProvider1.Clear();
txt_Suplier.Enabled = true;
txt_location.Enabled = true;
txt_remark.Enabled = true;
dataGridView1.Enabled = true;
dtx.Clear();
dataGridView1.Refresh();
txt_Suplier.Text = "";
txt_location.Text = "";
txt_remark.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(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on updating data", 1);
}
}
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["POFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["POSQL"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["POField" + 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 (txt_sourceLocId.Text.Trim().ToUpper() == txt_destinationLocId.Text.Trim().ToUpper())
{
errorProvider1.SetError(txt_destinationLocId, "Destination location cannot same as login location");
return;
}
if (!M_LocaDL.ExistingM_Loca(txt_sourceLocId.Text.Trim()))
{
errorProvider1.SetError(txt_sourceLocId, "Location does not exists on the system ");
commonFunctions.SetMDIStatusMessage("Location does not exists on the system", 1);
return;
}
if (!M_LocaDL.ExistingM_Loca(txt_destinationLocId.Text.Trim()))
{
errorProvider1.SetError(txt_destinationLocId, "Destination Location does not exists on the system ");
commonFunctions.SetMDIStatusMessage("Destination Location does not exists on the system", 1);
return;
}
if (commonFunctions.GetNoofItems(dataGridView1) <= 0)
{
errorProvider1.SetError(dataGridView1, "Please enter some items to the details grid");
commonFunctions.SetMDIStatusMessage("Please enter some items to the details grid", 1);
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_trnsferInNote objt_trnsferInNote = new t_trnsferInNote();
objt_trnsferInNote.transinNo = txt_no.Text.Trim();
objt_trnsferInNote.sourceLocId = commonFunctions.GlobalLocation;
objt_trnsferInNote.date = dte_date.Value;
objt_trnsferInNote.refNo = txt_refNo.Text.Trim();
objt_trnsferInNote.remarks = txt_remarks.Text.Trim();
objt_trnsferInNote.destinationLocId = txt_destinationLocId.Text.Trim();
objt_trnsferInNote.purchaseReqNo = txt_purchaseReqNo.Text.Trim();
objt_trnsferInNote.noOfItems = commonFunctions.ToDecimal(txt_noOfItems.Text.Trim());
objt_trnsferInNote.noOfPeaces = commonFunctions.ToDecimal(txt_noOfPeaces.Text.Trim());
objt_trnsferInNote.grossAmount = commonFunctions.ToDecimal(txt_grossAmount.Text.Trim());
objt_trnsferInNote.isProcessed = false;
objt_trnsferInNote.processDate = DateTime.Now;
objt_trnsferInNote.processUser = "";
objt_trnsferInNote.GLUpdate = false;
objt_trnsferInNote.triggerVal = 1;
T_trnsferInNoteDL bal = new T_trnsferInNoteDL();
bal.Savet_trnsferInNoteSP(objt_trnsferInNote, 1);
//save details
foreach (DataGridViewRow drow in dataGridView1.Rows)
{
if (drow.Cells["Product Code"].Value.ToString().Trim() != null)
{
t_transferIn_detail objt_transferIn_detail = new t_transferIn_detail();
objt_transferIn_detail.transinrNo = txt_no.Text.Trim();
objt_transferIn_detail.sourceLocId = commonFunctions.GlobalLocation;
objt_transferIn_detail.destinationLocId = txt_destinationLocId.Text.Trim();
objt_transferIn_detail.transferDate = dte_date.Value;
objt_transferIn_detail.stockCode = drow.Cells["Product Code"].Value.ToString();
objt_transferIn_detail.description = drow.Cells["Product Name"].Value.ToString();
objt_transferIn_detail.quantity = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString());
objt_transferIn_detail.costPrice = commonFunctions.ToDecimal(drow.Cells["Cost Price"].Value.ToString());
objt_transferIn_detail.amount = commonFunctions.ToDecimal(drow.Cells["Amount"].Value.ToString());
objt_transferIn_detail.triggerVal = 1;
T_transferIn_detailDL bal2 = new T_transferIn_detailDL();
bal2.Savet_transferIn_detailSP(objt_transferIn_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)
{
// u_DBConnection.RollbackTrans();
LogFile.WriteErrorLog("Save Transactions", "Transfer In", ex.Message);
LogFile.WriteErrorLog("Save Transactions", "Transfer Out", ex.Message);
commonFunctions.SetMDIStatusMessage("Transfer Number you have entered already processed", 1);
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
UpdateStock();
t_trnsferInNote objt_trnsferNote = new t_trnsferInNote();
objt_trnsferNote.transinNo = txt_no.Text.Trim();
T_trnsferInNoteDL balprocess = new T_trnsferInNoteDL();
objt_trnsferNote = balprocess.Selectt_trnsferInNote(objt_trnsferNote);
objt_trnsferNote.isProcessed = true;
objt_trnsferNote.processDate = DateTime.Now;
objt_trnsferNote.processUser = commonFunctions.Loginuser;
balprocess.Savet_trnsferInNoteSP(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_trnsferInNote cat = new t_trnsferInNote();
cat.transinNo = txt_no.Text.Trim();
T_trnsferInNoteDL dl = new T_trnsferInNoteDL();
cat = dl.Selectt_trnsferInNote(cat);
if (cat.isProcessed == false)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
UpdateStock();
t_trnsferInNote objt_trnsferNote = new t_trnsferInNote();
objt_trnsferNote.transinNo = txt_no.Text.Trim();
T_trnsferInNoteDL balprocess = new T_trnsferInNoteDL();
objt_trnsferNote = balprocess.Selectt_trnsferInNote(objt_trnsferNote);
objt_trnsferNote.isProcessed = true;
objt_trnsferNote.processDate = DateTime.Now;
objt_trnsferNote.processUser = commonFunctions.Loginuser;
balprocess.Savet_trnsferInNoteSP(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_refNo.Focus();
}
}
else
{
errorProvider1.SetError(txt_no, "Transfer IN 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(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on loading data", 1);
}
}
private void btn_addrange_Click(object sender, EventArgs e)
{
string salesman = "";
if (dgsalesman.SelectedRows.Count > 0)
{
if (dgsalesman.SelectedRows[0].Cells[0].Value.ToString() != "")
{
salesman = dgsalesman.SelectedRows[0].Cells[0].Value.ToString();
}
}
else
{
commonFunctions.SetMDIStatusMessage("Please select a salesman", 1);
return;
}
//if (dgitem.SelectedRows.Count > 0)
//{
// if (dgsalesman.SelectedRows[0].Cells[0].Value.ToString() != "")
// {
// salesman = dgsalesman.SelectedRows[0].Cells[0].Value.ToString();
// }
//}
//else
//{
// commonFunctions.SetMDIStatusMessage("Please select a salesman", 1);
// return;
//}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
foreach (DataGridViewRow drow in dgitems.Rows)
{
if (drow.Cells[0].Value.ToString().Trim() != null)
{
if (commonFunctions.ToDecimal(drow.Cells[2].Value.ToString().Trim()) <= 0)
{
continue;
}
T_SalesAllocHead objt_SalesAllocHead = new T_SalesAllocHead();
objt_SalesAllocHead.Docno = commonFunctions.GetSerial("A0062");
objt_SalesAllocHead.Salesman = salesman.Trim();
objt_SalesAllocHead.Item = drow.Cells[0].Value.ToString().Trim();
objt_SalesAllocHead.AllocQTY = commonFunctions.ToDecimal(drow.Cells[2].Value.ToString().Trim());
objt_SalesAllocHead.DateFrom = dte_datefrom.Value;
objt_SalesAllocHead.Dateto = dte_dateto.Value;
objt_SalesAllocHead.Userx = commonFunctions.Loginuser;
objt_SalesAllocHead.Datex = DateTime.Now;
new T_SalesAllocHeadDL().Savet_SalesAllocHeadSP(objt_SalesAllocHead, 1);
commonFunctions.IncrementSerial("A0062");
}
}
GetAllocations(selectedsalesman);
LoadData("", 3);
}
}
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["POFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["POSQL"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["POField" + 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 ");
commonFunctions.SetMDIStatusMessage("Location does not exists on the system", 1);
return;
}
if (commonFunctions.GetNoofItems(dataGridView1) <= 0)
{
errorProvider1.SetError(dataGridView1, "Please enter some items to the details grid");
commonFunctions.SetMDIStatusMessage("Please enter some items to the details grid", 1);
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_adjustment_head objt_adjustment_head = new t_adjustment_head();
objt_adjustment_head.adju_no = txt_no.Text.Trim();
objt_adjustment_head.location_id = commonFunctions.GlobalLocation;
objt_adjustment_head.adjsment_date = dte_date.Value;
objt_adjustment_head.remarks = txt_remarks.Text.Trim();
objt_adjustment_head.user_id = commonFunctions.Loginuser;
objt_adjustment_head.batch_no = txt_batch_no.Text.Trim();
objt_adjustment_head.process = false;
objt_adjustment_head.process_user = commonFunctions.Loginuser;
objt_adjustment_head.process_date = DateTime.Now;
objt_adjustment_head.triggerVal = 1;
T_adjustment_headDL bal = new T_adjustment_headDL();
bal.Savet_adjustment_headSP(objt_adjustment_head, 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_adjustment_details objt_adjustment_detail = new t_adjustment_details();
objt_adjustment_detail.adju_no = txt_no.Text.Trim();
objt_adjustment_detail.location_id = commonFunctions.GlobalLocation;
objt_adjustment_detail.line_no = 1;
objt_adjustment_detail.item_code = drow.Cells["Product Code"].Value.ToString();
objt_adjustment_detail.cost = commonFunctions.ToDecimal(drow.Cells["Cost Price"].Value.ToString());
objt_adjustment_detail.stock = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString());
objt_adjustment_detail.physical_quantity = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString()); //txt_physical_quantity.Text.Trim();
objt_adjustment_detail.variance = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString());
if (rdo_add.Checked)
{
objt_adjustment_detail.triggerVal = 1;
}
if (rdo_reduce.Checked)
{
objt_adjustment_detail.triggerVal = 2;
}
T_adjustment_detailDL bal2 = new T_adjustment_detailDL();
bal2.Savet_adjustment_detailSP(objt_adjustment_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)
{
// u_DBConnection.RollbackTrans();
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on loading data", 1);
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
UpdateStock();
t_adjustment_head objt_trnsferNote = new t_adjustment_head();
objt_trnsferNote.adju_no = txt_no.Text.Trim();
T_adjustment_headDL balprocess = new T_adjustment_headDL();
objt_trnsferNote = balprocess.Selectt_adjustment_head(objt_trnsferNote);
objt_trnsferNote.process = true;
objt_trnsferNote.process_date = DateTime.Now;
objt_trnsferNote.process_user = commonFunctions.Loginuser;
balprocess.Savet_adjustment_headSP(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_adjustment_head cat = new t_adjustment_head();
cat.adju_no = txt_no.Text.Trim();
T_adjustment_headDL dl = new T_adjustment_headDL();
cat = dl.Selectt_adjustment_head(cat);
if (cat.process == false)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
cat.location_id = txt_sourceLocId.Text.Trim();
cat.adjsment_date = dte_date.Value;
cat.remarks = txt_remarks.Text.Trim();
cat.user_id = commonFunctions.Loginuser;
cat.batch_no = txt_batch_no.Text.Trim();
new T_adjustment_headDL().Savet_adjustment_headSP(cat, 3);
List <t_adjustment_details> detsx = new List <t_adjustment_details>();
t_adjustment_details detx = new t_adjustment_details();
detx.adju_no = cat.adju_no.Trim();
detsx = new T_adjustment_detailDL().SelectT_adjustment_detailMulti(detx);
foreach (t_adjustment_details det in detsx)
{
new T_adjustment_detailDL().Savet_adjustment_detailSP(det, 4);
}
//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_adjustment_details objt_adjustment_detail = new t_adjustment_details();
objt_adjustment_detail.adju_no = txt_no.Text.Trim();
objt_adjustment_detail.location_id = txt_sourceLocId.Text.Trim();
objt_adjustment_detail.line_no = 1;
objt_adjustment_detail.item_code = drow.Cells["Product Code"].Value.ToString();
objt_adjustment_detail.cost = commonFunctions.ToDecimal(drow.Cells["Cost Price"].Value.ToString());
objt_adjustment_detail.stock = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString());
objt_adjustment_detail.physical_quantity = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString()); //txt_physical_quantity.Text.Trim();
objt_adjustment_detail.variance = commonFunctions.ToDecimal(drow.Cells["Quntity"].Value.ToString());
if (rdo_add.Checked)
{
objt_adjustment_detail.triggerVal = 1;
}
if (rdo_reduce.Checked)
{
objt_adjustment_detail.triggerVal = 2;
}
T_adjustment_detailDL bal2 = new T_adjustment_detailDL();
bal2.Savet_adjustment_detailSP(objt_adjustment_detail, 1);
}
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
cat.process = true;
cat.process_date = DateTime.Now;
cat.process_user = commonFunctions.Loginuser;
new T_adjustment_headDL().Savet_adjustment_headSP(cat, 3);
UpdateStock();
}
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, "Adjustment Number you have entered already processed.");
commonFunctions.SetMDIStatusMessage("Adjustment Number you have entered already processed", 1);
}
}
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(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on updating data", 1);
}
}
private void btn_save_Click(object sender, EventArgs e)
{
try
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
if (dgsaved.SelectedRows.Count > 0)
{
bool exists = false;
List <string> itemsx = new List <string>();
foreach (DataGridViewRow rowx in dgsaved.SelectedRows)
{
string x = rowx.Cells[0].Value.ToString();
T_SalesAllocDet det = new T_SalesAllocDet();
det.Docno = x.ToString();
List <T_SalesAllocDet> dets = new List <T_SalesAllocDet>();
dets = new T_SalesAllocDetDL().SelectT_SalesAllocDetMulti(det);
if (dets.Count > 0)
{
itemsx.Add(x);
exists = true;
}
else
{
T_SalesAllocHead head = new T_SalesAllocHead();
head.Docno = rowx.Cells[0].Value.ToString();
head = new T_SalesAllocHeadDL().Selectt_SalesAllocHead(head);
new T_SalesAllocHeadDL().Savet_SalesAllocHeadSP(head, 4);
}
}
GetAllocations(selectedsalesman);
if (exists == true)
{
string numbers = "";
foreach (string x in itemsx)
{
numbers += "\n" + x;
}
UserDefineMessages.ShowMsg1("Selected Allocation headers deleted except these " + numbers + " \nbecouse they have breakdowns", UserDefineMessages.Msg_Warning);
}
else
{
UserDefineMessages.ShowMsg1("Selected Allocation headers were deleted ", UserDefineMessages.Msg_Information);
}
}
else
{
string x = dgsaved.SelectedRows[0].Cells[0].Value.ToString();
T_SalesAllocDet det = new T_SalesAllocDet();
det.Docno = x.ToString();
List <T_SalesAllocDet> dets = new List <T_SalesAllocDet>();
dets = new T_SalesAllocDetDL().SelectT_SalesAllocDetMulti(det);
if (dets.Count > 0)
{
UserDefineMessages.ShowMsg1("Cannot delete the allocation master: " + x + ". becouse it has breakdowns ", UserDefineMessages.Msg_Warning);
}
else
{
T_SalesAllocHead head = new T_SalesAllocHead();
head.Docno = dgsaved.SelectedRows[0].Cells[0].Value.ToString();
head = new T_SalesAllocHeadDL().Selectt_SalesAllocHead(head);
new T_SalesAllocHeadDL().Savet_SalesAllocHeadSP(head, 4);
GetAllocations(selectedsalesman);
UserDefineMessages.ShowMsg1("Allocation header detleted NO: " + x, UserDefineMessages.Msg_Information);
}
}
}
}
catch (Exception ex) { }
}
private void performButtons(xEnums.PerformanceType xenum)
{
switch (xenum)
{
case xEnums.PerformanceType.View:
if (ActiveControl.Name.Trim() == txt_VehicleID.Name.Trim())
{
int length = Convert.ToInt32(ConfigurationManager.AppSettings["VehicleFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["VehicleSQL"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["VehicleField" + 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_VehicleID.Focus();
errorProvider1.Clear();
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 (txt_VehicleNo.Text.Trim() == "")
{
errorProvider1.SetError(txt_VehicleNo, "Please enter a vehicle number !");
return;
}
if (txt_VehicleID.Text.Trim() == "")
{
errorProvider1.SetError(txt_VehicleID, "Please enter a vehicle ID !");
return;
}
if (incomingvehicle.Trim().ToUpper() != txt_VehicleNo.Text.Trim())
{
if (M_VehicleDL.ExistingM_VehicleNo(txt_VehicleNo.Text.Trim()))
{
errorProvider1.SetError(txt_VehicleNo, "The vehicle number you have entered already exists!");
return;
}
}
if (formMode == 1)
{
if (M_VehicleDL.ExistingM_Vehicle(txt_VehicleID.Text.Trim()))
{
errorProvider1.SetError(txt_VehicleID, "The vehicle code you have entered already exists!");
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_Vehicles objm_Vehicle = new M_Vehicles();
objm_Vehicle.VehicleID = txt_VehicleID.Text.Trim();
objm_Vehicle.VehicleNo = txt_VehicleNo.Text.Trim();
objm_Vehicle.CompCode = commonFunctions.GlobalCompany; //txt_CompCode.Text.Trim();
objm_Vehicle.Locacode = commonFunctions.GlobalLocation; //txt_Locacode.Text.Trim();
objm_Vehicle.Make = txt_Make.Text.Trim();
objm_Vehicle.Model = txt_Model.Text.Trim();
objm_Vehicle.Driver = txt_Driver.Text.Trim();
objm_Vehicle.Milage = txt_Milage.Text.Trim();
objm_Vehicle.FuelEfficiency = commonFunctions.ToDecimal(txt_FuelEfficiency.Text.Trim());
objm_Vehicle.Status = txt_Status.Text.Trim();
objm_Vehicle.Route = txt_Route.Text.Trim();
objm_Vehicle.Userx = commonFunctions.Loginuser; //txt_Userx.Text.Trim();
objm_Vehicle.Datex = DateTime.Now; //txt_Datex.Text.Trim();
M_VehicleDL bal = new M_VehicleDL();
bal.SaveM_VehicleSP(objm_Vehicle, 1);
GetData();
txt_VehicleID.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
}
else if (formMode == 3)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_Vehicles objm_Vehicle = new M_Vehicles();
objm_Vehicle.VehicleID = txt_VehicleID.Text.Trim();
objm_Vehicle.VehicleNo = txt_VehicleNo.Text.Trim();
objm_Vehicle.CompCode = commonFunctions.GlobalCompany; //txt_CompCode.Text.Trim();
objm_Vehicle.Locacode = commonFunctions.GlobalLocation; //txt_Locacode.Text.Trim();
objm_Vehicle.Make = txt_Make.Text.Trim();
objm_Vehicle.Model = txt_Model.Text.Trim();
objm_Vehicle.Driver = txt_Driver.Text.Trim();
objm_Vehicle.Milage = txt_Milage.Text.Trim();
objm_Vehicle.FuelEfficiency = commonFunctions.ToDecimal(txt_FuelEfficiency.Text.Trim());
objm_Vehicle.Status = txt_Status.Text.Trim();
objm_Vehicle.Route = txt_Route.Text.Trim();
objm_Vehicle.Userx = commonFunctions.Loginuser; //txt_Userx.Text.Trim();
objm_Vehicle.Datex = DateTime.Now; //txt_Datex.Text.Trim();
M_VehicleDL bal = new M_VehicleDL();
bal.SaveM_VehicleSP(objm_Vehicle, 3);
GetData();
txt_VehicleID.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
}
}
break;
case xEnums.PerformanceType.Cancel:
txt_VehicleID.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Default);
errorProvider1.Clear();
break;
case xEnums.PerformanceType.Print:
UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information);
break;
}
}
private void performButtons(xEnums.PerformanceType xenum)
{
switch (xenum)
{
case xEnums.PerformanceType.View:
if (ActiveControl.Name.Trim() == txt_SalesmanID.Name.Trim())
{
int length = Convert.ToInt32(ConfigurationManager.AppSettings["SalesmanFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["SalesmanSQL"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["SalesmanField" + m + ""].ToString();
}
frmU_Search find = new frmU_Search(strSQL, strSearchField, this);
find.ShowDialog(this);
}
break;
case xEnums.PerformanceType.New:
FunctionButtonStatus(xEnums.PerformanceType.New);
//txt_IDX.Text = commonFunctions.GetSerial("A0009");
formMode = 1;
txt_SalesmanID.Focus();
errorProvider1.Clear();
break;
case xEnums.PerformanceType.Edit:
FunctionButtonStatus(xEnums.PerformanceType.Edit);
formMode = 3;
txt_SalesmanID.Enabled = false;
txt_SalesmanName.Focus();
errorProvider1.Clear();
break;
case xEnums.PerformanceType.Save:
errorProvider1.Clear();
if (txt_SalesmanID.Text.Trim().ToUpper() == "ADMIN")
{
errorProvider1.SetError(txt_SalesmanID, "This user is the system administrator. you cannot change the details.");
commonFunctions.SetMDIStatusMessage("This user is the system administrator. you cannot change the details.", 1);
return;
}
if (txt_SalesmanID.Text.Trim() == "")
{
errorProvider1.SetError(txt_SalesmanID, "User code cannot be a null value.");
commonFunctions.SetMDIStatusMessage("User code cannot be a null value.", 1);
return;
}
if (txt_SalesmanID.Text.Trim().Length < 5)
{
errorProvider1.SetError(txt_SalesmanID, "User code must be more than 6 charactors.");
commonFunctions.SetMDIStatusMessage("User code must be more than 6 charactors", 1);
return;
}
if (txt_SalesmanName.Text.Trim() == "")
{
errorProvider1.SetError(txt_SalesmanName, "User name cannot be a null value.");
commonFunctions.SetMDIStatusMessage("User name cannot be a null value.", 1);
return;
}
if (txtPw.Text == "")
{
errorProvider1.SetError(txtPw, "Password cannot be a null value.");
commonFunctions.SetMDIStatusMessage("Password cannot be a null value.", 1);
return;
}
if (txtPw.Text != txtRePw.Text)
{
errorProvider1.SetError(txtPw, "Password and the confirmation password must be same");
commonFunctions.SetMDIStatusMessage("Password and the confirmation password must be same.", 1);
return;
}
if (!U_UserRolexDL.ExistingU_UserRole(txtusergroup.Text.Trim()))
{
errorProvider1.SetError(txtusergroup, "User group already exists.");
commonFunctions.SetMDIStatusMessage("User group already exists.", 1);
return;
}
if (txt_SalesmanName.Text.Trim() == "")
{
errorProvider1.SetError(txt_SalesmanName, "Please enter a employee name !");
commonFunctions.SetMDIStatusMessage("Please enter a employee name.", 1);
return;
}
if (txt_SalesmanID.Text.Trim() == "")
{
errorProvider1.SetError(txt_SalesmanID, "Please enter a employee name !");
commonFunctions.SetMDIStatusMessage("Please enter a employee name.", 1);
return;
}
if (formMode == 1)
{
if (U_UserxDL.ExistingU_User(txt_SalesmanID.Text.Trim()))
{
errorProvider1.SetError(txt_SalesmanID, "User code already exists.");
commonFunctions.SetMDIStatusMessage("User code already exists.", 1);
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
u_Userxcc obju_User = new u_Userxcc();
obju_User.userId = txt_SalesmanID.Text.Trim();
obju_User.userName = txt_SalesmanName.Text.Trim();
obju_User.password = commonFunctions.CreateCheckPassword(true, txtPw.Text.Trim());
obju_User.roleId = txtusergroup.Text.Trim();
obju_User.userCreated = commonFunctions.Loginuser;
obju_User.dateCreated = DateTime.Now;
obju_User.userModified = "";
obju_User.dateModified = DateTime.Now;
obju_User.isActive = 1;
obju_User.Type = txt_paymeth.Text.Trim().ToUpper();
obju_User.Compcode = commonFunctions.GlobalCompany;
obju_User.Locacode = commonFunctions.GlobalLocation;
obju_User.TP = txt_TP.Text.Trim();
obju_User.Fax = txt_Fax.Text.Trim();
obju_User.Email = txt_Email.Text.Trim();
obju_User.Address1 = txt_Address1.Text.Trim();
obju_User.Address2 = txt_Address2.Text.Trim();
obju_User.Address3 = txt_Address3.Text.Trim();
obju_User.ContactPerson = txt_ContactPerson.Text.Trim();
obju_User.ContactPersonNo = txt_ContactPersonNo.Text.Trim();
obju_User.CurrentStatus = "Active";
obju_User.Gradex = "Good";
obju_User.NICNo = txt_nic.Text.Trim();
new U_UserxDL().Saveu_UserSP(obju_User, 1);
GetData();
txt_SalesmanID.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2);
}
}
else if (formMode == 3)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
u_Userxcc obju_User = new u_Userxcc();
obju_User.userId = txt_SalesmanID.Text.Trim();
obju_User = new U_UserxDL().Selectu_User(obju_User);
obju_User.userId = txt_SalesmanID.Text.Trim();
obju_User.userName = txt_SalesmanName.Text.Trim();
obju_User.password = commonFunctions.CreateCheckPassword(true, txtPw.Text.Trim());
obju_User.roleId = txtusergroup.Text.Trim();
obju_User.userCreated = commonFunctions.Loginuser;
obju_User.dateCreated = DateTime.Now;
obju_User.userModified = "";
obju_User.dateModified = DateTime.Now;
obju_User.isActive = 1;
obju_User.Type = txt_paymeth.Text.Trim().ToUpper();
obju_User.Compcode = commonFunctions.GlobalCompany;
obju_User.Locacode = commonFunctions.GlobalLocation;
obju_User.TP = txt_TP.Text.Trim();
obju_User.Fax = txt_Fax.Text.Trim();
obju_User.Email = txt_Email.Text.Trim();
obju_User.Address1 = txt_Address1.Text.Trim();
obju_User.Address2 = txt_Address2.Text.Trim();
obju_User.Address3 = txt_Address3.Text.Trim();
obju_User.ContactPerson = txt_ContactPerson.Text.Trim();
obju_User.ContactPersonNo = txt_ContactPersonNo.Text.Trim();
obju_User.CurrentStatus = "Active";
obju_User.Gradex = "Good";
obju_User.NICNo = txt_nic.Text.Trim();
new U_UserxDL().Saveu_UserSP(obju_User, 3);
GetData();
txt_SalesmanID.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2);
}
}
break;
case xEnums.PerformanceType.Cancel:
txt_SalesmanID.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Default);
errorProvider1.Clear();
break;
case xEnums.PerformanceType.Print:
UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information);
break;
}
}
private void performButtons(xEnums.PerformanceType xenum)
{
switch (xenum)
{
case xEnums.PerformanceType.View:
if (ActiveControl.Name.Trim() == txt_AreaCode.Name.Trim())
{
int length = Convert.ToInt32(ConfigurationManager.AppSettings["AreaFieldLength"]);
string[] strSearchField = new string[length];
string strSQL = ConfigurationManager.AppSettings["AreaSQL"].ToString();
for (int i = 0; i < length; i++)
{
string m;
m = i.ToString();
strSearchField[i] = ConfigurationManager.AppSettings["AreaField" + 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_AreaCode.Focus();
errorProvider1.Clear();
break;
case xEnums.PerformanceType.Edit:
FunctionButtonStatus(xEnums.PerformanceType.Edit);
formMode = 3;
txt_AreaCode.Enabled = false;
txt_Descri.Focus();
errorProvider1.Clear();
break;
case xEnums.PerformanceType.Save:
try
{
if (txt_AreaCode.Text.Trim() == "")
{
errorProvider1.SetError(txt_AreaCode, "Please enter a area Code !");
return;
}
if (txt_Descri.Text.Trim() == "")
{
errorProvider1.SetError(txt_Descri, "Please enter a area name !");
return;
}
if (formMode == 1)
{
if (M_AreaDL.ExistingM_Area(txt_AreaCode.Text.Trim()))
{
errorProvider1.SetError(txt_AreaCode, "The area code you have entered already exists!");
return;
}
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_Area objm_Area = new M_Area();
objm_Area.AreaCode = txt_AreaCode.Text.Trim();
objm_Area.Compcode = commonFunctions.GlobalCompany; // txt_Compcode.Text.Trim();
objm_Area.Locacode = commonFunctions.GlobalLocation; // txt_Locacode.Text.Trim();
objm_Area.Descri = txt_Descri.Text.Trim();
objm_Area.Datex = DateTime.Now; //txt_Datex.Text.Trim();
objm_Area.Userx = commonFunctions.Loginuser; // txt_Userx.Text.Trim();
M_AreaDL bal = new M_AreaDL();
bal.SaveM_AreaSP(objm_Area, 1);
GetData();
txt_AreaCode.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Save_Sucess, commonFunctions.Softwarename.Trim());
}
}
else if (formMode == 3)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_Area objm_Area = new M_Area();
objm_Area.AreaCode = txt_AreaCode.Text.Trim();
objm_Area.Compcode = commonFunctions.GlobalCompany; // txt_Compcode.Text.Trim();
objm_Area.Locacode = commonFunctions.GlobalLocation; // txt_Locacode.Text.Trim();
objm_Area.Descri = txt_Descri.Text.Trim();
objm_Area.Datex = DateTime.Now; //txt_Datex.Text.Trim();
objm_Area.Userx = commonFunctions.Loginuser; // txt_Userx.Text.Trim();
M_AreaDL bal = new M_AreaDL();
bal.SaveM_AreaSP(objm_Area, 3);
GetData();
txt_AreaCode.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_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);
}
break;
case xEnums.PerformanceType.Cancel:
txt_AreaCode.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Default);
errorProvider1.Clear();
break;
case xEnums.PerformanceType.Print:
UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information);
break;
}
}
private void btn_addSub_Click(object sender, EventArgs e)
{
if (txt_subcatname.Text.Trim() == "")
{
errorProvider1.SetError(txt_subcatname, "Please enter a subcategory name !");
return;
}
lbl_newsub.Hide();
try
{
if (!M_SubCategoryDL.ExistingM_SubCategory(txt_Codex.Text, txt_subcatcode.Text.Trim()))
{
lbl_newsub.Show();
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_SubCategory objm_SubCategory = new M_SubCategory();
objm_SubCategory.Codex = txt_subcatcode.Text.Trim();
objm_SubCategory.CategoryID = txt_Codex.Text.Trim();
objm_SubCategory.Descr = txt_subcatname.Text.Trim();
objm_SubCategory.date = DateTime.Now;
objm_SubCategory.type = "";
objm_SubCategory.Lockedby = commonFunctions.Loginuser;
objm_SubCategory.Locked = chk_locksub.Checked;
objm_SubCategory.Userx = commonFunctions.Loginuser;
new M_SubCategoryDL().Savem_SubCategorySP(objm_SubCategory, 1);
GetData();
txt_Codex.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Save_Sucess, commonFunctions.Softwarename.Trim());
}
}
else
{
lbl_newsub.Hide();
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
M_SubCategory objm_SubCategory = new M_SubCategory();
objm_SubCategory.Codex = txt_subcatcode.Text.Trim();
objm_SubCategory.CategoryID = txt_Codex.Text.Trim();
objm_SubCategory.Descr = txt_subcatname.Text.Trim();
objm_SubCategory.date = DateTime.Now;
objm_SubCategory.type = "";
objm_SubCategory.Lockedby = commonFunctions.Loginuser;
objm_SubCategory.Locked = chk_locksub.Checked;
objm_SubCategory.Userx = commonFunctions.Loginuser;
new M_SubCategoryDL().Savem_SubCategorySP(objm_SubCategory, 3);
GetData();
txt_Codex.Enabled = true;
FunctionButtonStatus(xEnums.PerformanceType.Save);
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 loading data", 1);
}
}
