private Boolean updateDashBoard(productmodels pm, int stat)
{
Boolean status = true;
try
{
dashboardalarm dsb = new dashboardalarm();
DashboardDB ddsDB = new DashboardDB();
dsb.DocumentID = docID;
//dsb.TemporaryNo = pm.TemporaryNo;
//dsb.TemporaryDate = pm.TemporaryDate;
//dsb.DocumentNo = pm.DocumentNo;
//dsb.DocumentDate = pm.DocumentDate;
dsb.FromUser = Login.userLoggedIn;
if (stat == 1)
{
dsb.ActivityType = 2;
dsb.ToUser = prevpmodel.ForwardUser;
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
else if (stat == 2)
{
dsb.ActivityType = 3;
List <documentreceiver> docList = DocumentReceiverDB.getDocumentWiseReceiver(docID);
foreach (documentreceiver docRec in docList)
{
dsb.ToUser = docRec.EmployeeID; //To store UserID Form DocumentReceiver for current Document
dsb.DocumentDate = UpdateTable.getSQLDateTime();
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public void clearData()
{
try
{
//----------clear temperory panels
clearTabPageControls();
pnlForwarder.Visible = false;
txtModelName.Text = "";
txtModelNo.Text = "";
txtStockItemID.Text = "";
txtRemarks.Text = "";
prevpmodel = new productmodels();
//removeControlsFromForwarderPanel();
//removeControlsFromForwarderPanelTV();
}
catch (Exception ex)
{
}
}
private void grdList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex < 0)
{
return;
}
string columnName = grdList.Columns[e.ColumnIndex].Name;
if (columnName.Equals("Edit") || columnName.Equals("Approve") || columnName.Equals("LoadDocument") ||
columnName.Equals("View"))
{
clearData();
setButtonVisibility(columnName);
// QIHeaderDB qidb = new QIHeaderDB();
int rowID = e.RowIndex;
btnSave.Text = "Update";
DataGridViewRow row = grdList.Rows[rowID];
prevpmodel = new productmodels();
prevpmodel.rowID = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["RowID"].Value.ToString());
prevpmodel.StockItemID = grdList.Rows[e.RowIndex].Cells["StockItem"].Value.ToString();
prevpmodel.StockItemName = grdList.Rows[e.RowIndex].Cells["StockItemName"].Value.ToString();
prevpmodel.ModelNo = grdList.Rows[e.RowIndex].Cells["ModelNo"].Value.ToString();
prevpmodel.ModelName = grdList.Rows[e.RowIndex].Cells["ModelName"].Value.ToString();
prevpmodel.Remarks = grdList.Rows[e.RowIndex].Cells["Remarks"].Value.ToString();
//--------Load Documents
if (columnName.Equals("LoadDocument"))
{
string hdrString = "Model No:" + prevpmodel.ModelNo + "\n" +
"Model Detail:" + prevpmodel.ModelName + "\n" +
"Product ID:" + prevpmodel.StockItemID + "\n" +
"Product Name:" + prevpmodel.StockItemName;
string dicDir = Main.documentDirectory + "\\" + docID;
string subDir = prevpmodel.StockItemID + "-" + prevpmodel.ModelNo;
FileManager.LoadDocuments load = new FileManager.LoadDocuments(dicDir, subDir, docID, hdrString);
load.ShowDialog();
this.RemoveOwnedForm(load);
btnCancel_Click_2(null, null);
return;
}
//--------
prevpmodel.Status = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["gStatus"].Value.ToString());
prevpmodel.CreateTime = DateTime.Parse(grdList.Rows[e.RowIndex].Cells["gCreateTime"].Value.ToString());
prevpmodel.CreateUser = grdList.Rows[e.RowIndex].Cells["gCreateUser"].Value.ToString();
prevpmodel.CreatorName = grdList.Rows[e.RowIndex].Cells["Creator"].Value.ToString();
prevpmodel.ForwardUser = grdList.Rows[e.RowIndex].Cells["ForwardUser"].Value.ToString();
prevpmodel.ApproveUser = grdList.Rows[e.RowIndex].Cells["ApproveUser"].Value.ToString();
prevpmodel.DocumentStatus = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["DocumentStatusNo"].Value.ToString());
prevpmodel.ForwarderName = grdList.Rows[e.RowIndex].Cells["Forwarder"].Value.ToString();
prevpmodel.ApproverName = grdList.Rows[e.RowIndex].Cells["Approver"].Value.ToString();
prevpmodel.ForwarderList = grdList.Rows[e.RowIndex].Cells["Forwarders"].Value.ToString();
txtModelName.Text = prevpmodel.ModelName.ToString();
txtModelNo.Text = prevpmodel.ModelNo.ToString();
txtRemarks.Text = prevpmodel.Remarks;
txtStockItemID.Text = prevpmodel.StockItemID + "-" + prevpmodel.StockItemName;
btnSave.Text = "Update";
pnlList.Visible = false;
pnlAddEdit.Visible = true;
btnSave.Text = "Update";
pnlList.Visible = false;
pnlAddEdit.Visible = true;
tabControl1.SelectedTab = tabProductModel;
tabControl1.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Boolean status = true;
try
{
ProductModelsDB pmdb = new ProductModelsDB();
productmodels pm = new productmodels();
System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button;
string btnText = btnSave.Text;
try
{
pm.ModelName = txtModelName.Text;
pm.StockItemID = txtStockItemID.Text.Substring(0, txtStockItemID.Text.IndexOf('-'));
pm.Remarks = txtRemarks.Text;
pm.ForwarderList = prevpmodel.ForwarderList;
}
catch (Exception ex)
{
MessageBox.Show("Validation failed");
return;
}
if (pmdb.validateProductModel(pm))
{
if (btnText.Equals("Update"))
{
pm.DocumentStatus = prevpmodel.DocumentStatus;
if (pmdb.updateProductModels(pm, prevpmodel))
{
MessageBox.Show("Product Model Details updated");
closeAllPanels();
listOption = 1;
ListFilteredProductModels(listOption, pid);
}
else
{
status = false;
}
if (!status)
{
MessageBox.Show("Failed to update Product Model");
}
}
else if (btnText.Equals("Save"))
{
pm.DocumentStatus = 1;
if (pmdb.insertProductModel(pm))
{
MessageBox.Show("Product Model Details Added");
closeAllPanels();
listOption = 1;
ListFilteredProductModels(listOption, pid);
}
else
{
status = false;
}
if (!status)
{
MessageBox.Show("Failed to Insert Product Model");
}
}
}
else
{
MessageBox.Show("Product Model Validation failed");
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Product Model(Save()) : Error");
status = false;
}
if (status)
{
setButtonVisibility("btnEditPanel"); //activites are same for cancel, forward,approve, reverse and save
}
}
