protected void btnDeleteRow_Click(object sender, EventArgs e)
{
try
{
DTSpareReqComplt = (DataTable)ViewState["DataTableSpareReqComplt"];
GridViewRow gvrow = (GridViewRow)(((Control)sender).NamingContainer);
if (DTSpareReqComplt.Rows.Count > 0)
{
DTSpareReqComplt.Rows[gvrow.RowIndex].Delete();
DTSpareReqComplt.AcceptChanges();
ViewState["DataTableSpareReqComplt"] = DTSpareReqComplt;
DTSpareReqComplt = (DataTable)ViewState["DataTableSpareReqComplt"];
GvSpareReqComplaint.DataSource = DTSpareReqComplt;
GvSpareReqComplaint.DataBind();
////for (int i = 0; i < GvSpareReqComplaint.Rows.Count; i++)
////{
//// if (DTSpareReqComplt.Rows[i]["Proposed_Qty"].ToString() != "")
//// {
//// GvSpareReqComplaint.Rows[i].Cells[0].Enabled = false;
//// GvSpareReqComplaint.Rows[i].Cells[1].Enabled = false;
//// GvSpareReqComplaint.Rows[i].Cells[2].Enabled = false;
//// GvSpareReqComplaint.Rows[i].Cells[3].Enabled = false;
//// GvSpareReqComplaint.Rows[i].Cells[4].Enabled = false;
//// GvSpareReqComplaint.Rows[i].Cells[5].Enabled = false;
//// GvSpareReqComplaint.Rows[i].Cells[6].Enabled = true;
//// }
//// else
//// {
//// GvSpareReqComplaint.Rows[i].Cells[0].Enabled = true;
//// GvSpareReqComplaint.Rows[i].Cells[1].Enabled = true;
//// GvSpareReqComplaint.Rows[i].Cells[2].Enabled = true;
//// GvSpareReqComplaint.Rows[i].Cells[3].Enabled = true;
//// GvSpareReqComplaint.Rows[i].Cells[4].Enabled = true;
//// GvSpareReqComplaint.Rows[i].Cells[5].Enabled = true;
//// GvSpareReqComplaint.Rows[i].Cells[6].Enabled = true;
//// }
////}
}
else
{
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "Currently no row exists to delete!";
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
// bhawesh 28 sep 12
protected void txtProposedQty_TextChanged(object sender, EventArgs e)
{
try
{
GridViewRow gvrow = (GridViewRow)(((Control)sender).NamingContainer);
DropDownList ddlSpareCode = (DropDownList)gvrow.FindControl("ddlSpareCode");
TextBox lblCurrentStock = (TextBox)gvrow.FindControl("lblCurrentStock");
TextBox txtProposedQty = (TextBox)gvrow.FindControl("txtProposedQty");
DTSpareReqComplt = (DataTable)ViewState["DataTableSpareReqComplt"];
//////////// Validate Proposed quantity ///////////////
bool ValidQty = true;
int SpareMaxQty = 0;
if (ViewState["SpareMaxQty"] != null)
{
SpareMaxQty = Convert.ToInt32(ViewState["SpareMaxQty"]);
}
if (SpareMaxQty > 0)
{
if (Convert.ToInt32(txtProposedQty.Text.Trim()) > SpareMaxQty)
{
ValidQty = false;
lblMessage.Text = "Proposed Quantity can not be greater then BOM Quantity.";
txtProposedQty.Text = "0";
}
}
if (lblMessage.Text == "You already have spares.Use Indent screen !")
{
ValidQty = false;
txtProposedQty.Text = "0";
}
//////////////////////////////////////////////////////////
if (ValidQty)
{
DTSpareReqComplt.Rows[gvrow.RowIndex]["Spare_Id"] = ddlSpareCode.SelectedValue;
DTSpareReqComplt.Rows[gvrow.RowIndex]["Current_Stock"] = lblCurrentStock.Text;
DTSpareReqComplt.Rows[gvrow.RowIndex]["Proposed_Qty"] = txtProposedQty.Text.Trim();
DTSpareReqComplt.AcceptChanges();
ViewState["DataTableSpareReqComplt"] = DTSpareReqComplt;
lblMessage.Text = "";
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
//Add newly mapped cost center with product division
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
if (rdoStatus.SelectedValue == "1")
{
objCostCenter.CostCenterCode = txtCostCenterCode.Text;
objCostCenter.CostCenterDesc = txtCostCenterDesc.Text;
objCostCenter.BACode = txtBACode.Text;
objCostCenter.DivisionID = Convert.ToInt16(ddlDivision.SelectedValue);
objCostCenter.ActionBy = User.Identity.Name;
objCostCenter.Active_Flag = 1;
objCostCenter.Type = "INSERT_COST_CENTER";
objCostCenter.SaveCostCenter();
if (objCostCenter.ReturnValue != -1)
{
if (objCostCenter.MessageOut == "update")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.RecordUpdated, SIMSenuMessageType.UserMessage, false, "");
//ClearForm();
hdnCostCenterId.Value = "";
rdoStatus.SelectedValue = "1";
}
else if (objCostCenter.MessageOut == "Insert")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.AddRecord, SIMSenuMessageType.UserMessage, false, "");
ClearFrom();
}
else if (objCostCenter.MessageOut == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DulplicateRecord, SIMSenuMessageType.UserMessage, false, "");
}
}
BindGrid();
}
else
{
lblMessage.Text = "In-active record can not be created.";
}
}
catch (Exception ex)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void ddlASC_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
objSpareConsumption.ASC_Id = Convert.ToInt32(ddlASC.SelectedValue);
objSpareConsumption.BindProductDivisionData(ddlProductDivison);
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
FillRegionDropDownToolTip();
FillBranchDropDownToolTip();
FillDivisionDropDownToolTip();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
BindData("Region ASC");
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
FillASCDropDownToolTip();
FillRegionDropDownToolTip();
FillBranchDropDownToolTip();
FillDivisionDropDownToolTip();
}
protected void gvComm_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
try
{
imgBtnUpdateFGIntmd.Visible = true;
imgBtnAddFGIntmd.Visible = false;
//Assigning Product_Sno to Hiddenfield
hdnProductSNo.Value = gvComm.DataKeys[e.NewSelectedIndex].Value.ToString();
BindSelected(int.Parse(hdnProductSNo.Value.ToString()));
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
//Assigning values to properties
objASCLocMaster.Loc_Id = 0;
objASCLocMaster.ASC_Id = hdnASC_Id.Value; //ddlASCCode.SelectedValue.ToString();
objASCLocMaster.Loc_Code = txtLocCode.Text.Trim();
objASCLocMaster.Loc_Name = txtLocName.Text.Trim();
objASCLocMaster.Engineer_Code = ddlServiceEng.SelectedItem.Value;
objASCLocMaster.EmpCode = Membership.GetUser().UserName.ToString();
objASCLocMaster.ActiveFlag = rdoStatus.SelectedValue.ToString();
//objASCLocMaster.IsDefault_Loc = rdoDefaultLocation.SelectedValue.ToString();
string strMsg = objASCLocMaster.SaveData("INSERT_LOCATION");
if (objASCLocMaster.ReturnValue == -1)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
if (strMsg == "LocCodeExists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.LocCodeExists, SIMSenuMessageType.UserMessage, false, "");
}
else if (strMsg == "LocNameExists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.LocNameExists, SIMSenuMessageType.UserMessage, false, "");
}
else if (strMsg == "DefaultExists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DefaultExists, SIMSenuMessageType.UserMessage, false, "");
}
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.AddRecord, SIMSenuMessageType.UserMessage, false, "");
}
}
}
catch (Exception ex)
{
//Writing Error message to File using SIMSCommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
sqlParamSrh[4].Value = hdnASC_Id.Value;
objCommonClass.BindDataGrid(gvComm, "uspASCLocationMaster", true, sqlParamSrh, lblRowCount);
ClearControls();
}
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
objStockUpdate.ASCCode = ddlASCCode.SelectedItem.Value;
objStockUpdate.Division = ddlDivision.SelectedValue.ToString();
objStockUpdate.SpareCode = ddlSpareCode.SelectedValue.ToString();
objStockUpdate.LocId = ddlLocation.SelectedValue.ToString();
objStockUpdate.Qty = txtCurrentStock.Text.Trim();
objStockUpdate.CGInvoice = txtCGInvoice.Text.Trim();
objStockUpdate.ActionBy = Membership.GetUser().UserName.ToString();
objStockUpdate.ActionType = "INSERT_STOREUPDATE";
objStockUpdate.SaveStockUpdateMaster();
if (objStockUpdate.ReturnValue == -1)
{
//MESSAGE AT ERROR IN STORED PROCEDURE
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
//MESSAGE IF RECORD ALREADY EXIST
if (objStockUpdate.MessageOut == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DulplicateRecord, SIMSenuMessageType.UserMessage, false, "");
}
//MESSAGE AT INSERTION
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.AddRecord, SIMSenuMessageType.UserMessage, false, "");
ClearControls();
}
}
}
catch (Exception ex)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
finally
{
BindGrid();
ClearControls();
FillDropDownToolTip();
}
}
protected void imgBtnApprove_Click(object sender, EventArgs e)
{
CheckBox chkreject;
TextBox txtRejectionReason;
Label lbldocno;
HiddenField hdnSpareID;
HiddenField hdnBillNo;
HiddenField hdnQty;
String strSuc = "";
// bool flgApproved = true;
foreach (GridViewRow gr in GvDetails.Rows)
{
if (gr.RowType == DataControlRowType.DataRow)
{
chkreject = gr.FindControl("chkreject") as CheckBox;
txtRejectionReason = gr.FindControl("txtRejectionReason") as TextBox;
lbldocno = gr.FindControl("lbldocno") as Label;
hdnSpareID = gr.FindControl("hdnSpareID") as HiddenField;
hdnBillNo = gr.FindControl("hdnBillNo") as HiddenField;
hdnQty = gr.FindControl("hdnQty") as HiddenField;
if (!chkreject.Checked)
{
objASCSparePurchaseOutside.SpareId = Convert.ToInt32(hdnSpareID.Value);
objASCSparePurchaseOutside.AutoGeneratedNumber = lbldocno.Text;
objASCSparePurchaseOutside.UserName = Membership.GetUser().UserName.ToString();
objASCSparePurchaseOutside.IsApproved = true;
objASCSparePurchaseOutside.RejectionReason = txtRejectionReason.Text;
strSuc = objASCSparePurchaseOutside.ApprovalBills();
}
chkreject.Enabled = false;
txtRejectionReason.Enabled = false;
}
}
imgBtnApprove.Enabled = false;
imgBtnReject.Enabled = false;
if (objASCSparePurchaseOutside.ReturnValue == -1)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
lblMessage.Text = "Bills Approved Sucessfully.";
objASCSparePurchaseOutside.GetBillsForApproval(GvDetails);
System.Web.UI.ScriptManager.RegisterClientScriptBlock(imgBtnApprove, GetType(), "Approval", "javascript:CloseAfterApproval();", true);
}
}
protected void imgbtnSave_Click(object sender, EventArgs e)
{
try
{
bool blnSaveData = true;
string script = string.Empty;
if (lblwarrantystatus.Text.ToLower() == "y")
{
for (int i = 0; i < gvActivityCharges.Rows.Count; i++)
{
CheckBox chkActivityConfirm = (CheckBox)gvActivityCharges.Rows[i].FindControl("chkActivityConfirm");
if (chkActivityConfirm.Checked == true)
{
TextBox txtActualQty = (TextBox)gvActivityCharges.Rows[i].FindControl("txtActualQty");
if (txtActualQty.Text.Trim() == "")
{
blnSaveData = false;
lblMessage.Text = "Please enter quantity for selected activity.";
return;
}
}
}
}
if (blnSaveData == true)
{
objspareconsumeforcomplaint.Stage_Id = 62;
objspareconsumeforcomplaint.Complaint_No = lblComplaintNo.Text;
objspareconsumeforcomplaint.ASC_Id = Convert.ToInt32(hdnASC_Id.Value);
objspareconsumeforcomplaint.ProductDivision_Id = Convert.ToInt32(hdnProductDivision_Id.Value);
objspareconsumeforcomplaint.DeleteAllOldActivityCharges();
SaveActivityCost();
string strMessage = "";
if (hdnProposedSpares.Value != "")
{
strMessage = "Advice has been generated for spares: " + hdnProposedSpares.Value + ".\\n";
}
strMessage = strMessage + "Your record has been saved successfully.\\nAre you sure you want to close this window?";
script = "if(confirm('" + strMessage + "')==true){ window.close(); }";
ScriptManager.RegisterClientScriptBlock(imgbtnSave, GetType(), "Spare Consumption", script, true);
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
lblMessage.Text = "Unable To Perform Operation";
}
}
protected void ddlVendor_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
btnConfirm.Enabled = true;
if (ddlVendor.SelectedIndex != 0)
{
Fn_GetCurrentDataTable();
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
FillDropDownToolTip();
}
//method to select data on edit
private void BindSelected(int intProductSNo)
{
try
{
lblMessage.Text = "";
txtProductCode.Enabled = false;
rdoProdMapping.Enabled = false;
ddlProduct.Enabled = false;
objFGIntermediateScreen.BindProductOnSNo(intProductSNo, "SELECT_ON_PRODUCT_SNo");
ddlProduct.SelectedValue = objFGIntermediateScreen.ProductCode;
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void gvComm_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
gvComm.PageIndex = e.NewPageIndex;
BindData();
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
FillASCDropDownToolTip();
FillRegionDropDownToolTip();
FillBranchDropDownToolTip();
FillDivisionDropDownToolTip();
}
protected void imgBtnUpdate_Click(object sender, EventArgs e)
{
try
{
if (hdnBranchSNo.Value != "")
{
//Assigning values to properties
objSIMSBranchMaster.BranchSNo = int.Parse(hdnBranchSNo.Value.ToString());
objSIMSBranchMaster.BranchCode = txtBranchCode.Text.Trim();
objSIMSBranchMaster.RegionSNo = int.Parse(ddlRegionDesc.SelectedValue);
objSIMSBranchMaster.CitySNo = int.Parse(ddlCity.SelectedValue);
objSIMSBranchMaster.BranchName = txtBranchName.Text.Trim();
objSIMSBranchMaster.BranchAddress = txtBranchAddress.Text.Trim();
objSIMSBranchMaster.BranchPlantCode = txtBranchPlantCode.Text.Trim();
objSIMSBranchMaster.BranchPlantCodeDesc = txtBranchPlantDesc.Text.Trim();
objSIMSBranchMaster.EmpCode = Membership.GetUser().UserName.ToString();
objSIMSBranchMaster.ActiveFlag = rdoStatus.SelectedValue.ToString();
//Calling SaveData to save Branch Master and pass type "UPDATE_BRANCH" it return "" if record
//is not already exist otherwise exists
string strMsg = objSIMSBranchMaster.SaveData("UPDATE_BRANCH");
if (objSIMSBranchMaster.ReturnValue == -1)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
if (strMsg == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DulplicateRecord, SIMSenuMessageType.UserMessage, false, "");
}
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.RecordUpdated, SIMSenuMessageType.UserMessage, false, "");
}
}
}
}
catch (Exception ex)
{
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
objCommonClass.BindDataGrid(gvComm, "uspSIMSBranchMaster", true, sqlParamSrh, lblRowCount);
ClearControls();
}
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
//CalculateTrigger();
//Assigning values to properties
objASCSpecificSpare.ASC_Spec_Spare_Id = 0;
objASCSpecificSpare.ASC_Id = Convert.ToInt32(ddlASCCode.SelectedValue.ToString());
// objASCSpecificSpare.Loc_Id = Convert.ToInt32(ddlLocation.SelectedItem.Value.ToString());
objASCSpecificSpare.ProductDivision_Id = Convert.ToInt32(ddlProductDivision.SelectedItem.Value.ToString());
objASCSpecificSpare.Spare_Id = Convert.ToInt32(ddlSpare.SelectedItem.Value.ToString());
objASCSpecificSpare.Lead_Time = txtLeadTime.Text.Trim();
objASCSpecificSpare.AVGConsumption_Per_Day = txtAvgConsumption.Text.Trim();
objASCSpecificSpare.Safety_Percentage = txtSafety.Text.Trim();
objASCSpecificSpare.Reorder_Trigger = txtReorderTrigger.Text.Trim();
objASCSpecificSpare.Recommended_Stock = txtRecommendedStock.Text.Trim();
objASCSpecificSpare.Order_Quantity = txtOrderQuantity.Text.Trim();
objASCSpecificSpare.Min_Order_Quantity = txtMinOrderQty.Text.Trim();
objASCSpecificSpare.EmpCode = Membership.GetUser().UserName.ToString();
objASCSpecificSpare.ActiveFlag = rdoStatus.SelectedValue.ToString();
string strMsg = objASCSpecificSpare.SaveData("INSERT_ASC_SPEC_SPARE");
if (objASCSpecificSpare.ReturnValue == -1)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
if (strMsg == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DulplicateRecord, SIMSenuMessageType.UserMessage, false, "");
}
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.AddRecord, SIMSenuMessageType.UserMessage, false, "");
}
}
}
catch (Exception ex)
{
//Writing Error message to File using SIMSCommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
objCommonClass.BindDataGrid(gvComm, "uspASCSpecificSpareMaster", true, sqlParamSrh, lblRowCount);
ClearControls();
}
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
objActivity.Division = ddlDivision.SelectedValue.ToString();
objActivity.ActivityCode = txtActivityCode.Text.Trim();
objActivity.ActivityDesc = txtActivityDesc.Text.Trim();
objActivity.ActionBy = Membership.GetUser().UserName.ToString();
objActivity.ActiveFlag = rdoStatus.SelectedValue.ToString();
objActivity.Discount = txtDiscount.Text;
objActivity.ActionType = "INSERT_ACTIVITYMASTER";
objActivity.SaveActivityMaster();
if (objActivity.ReturnValue == -1)
{
//MESSAGE AT ERROR IN STORED PROCEDURE
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
//MESSAGE IF RECORD ALREADY EXIST
if (objActivity.MessageOut == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DulplicateRecord, SIMSenuMessageType.UserMessage, false, "");
}
//MESSAGE AT INSERTION
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.AddRecord, SIMSenuMessageType.UserMessage, false, "");
ClearControls();
}
}
}
catch (Exception ex)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
finally
{
BindGrid();
ClearControls();
}
}
//end
protected void imgBtnUpdate_Click(object sender, EventArgs e)
{
try
{
if (hdnId.Value != "")
{
//Assigning values to properties
objIncoTerms.Inco_Terms_Id = int.Parse(hdnId.Value.ToString());
objIncoTerms.Inco_Terms_Code = txtCode.Text.Trim();
objIncoTerms.Inco_Terms_Desc = txtDescription.Text.Trim();
objIncoTerms.EmpCode = Membership.GetUser().UserName.ToString();
objIncoTerms.ActiveFlag = rdoStatus.SelectedValue.ToString();
string strMsg = objIncoTerms.SaveData("UPDATE_INCO_TERMS");
if (objIncoTerms.ReturnValue == -1)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
if (strMsg == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DulplicateRecord, SIMSenuMessageType.UserMessage, false, "");
}
else if (strMsg == "InUse")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ActivateStatusNotChange, SIMSenuMessageType.UserMessage, false, "");
}
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.RecordUpdated, SIMSenuMessageType.UserMessage, false, "");
objCommonClass.BindDataGrid(gvComm, "uspIncoTerms", true, sqlParamSrh, lblRowCount);
ClearControls();
}
}
}
}
catch (Exception ex)
{
//Writing Error message to File using SIMSCommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
//objCommonClass.BindDataGrid(gvComm, "uspIncoTerms", true, sqlParamSrh, lblRowCount);
//ClearControls();
}
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
objParameter.ProductDivision_Id = Convert.ToInt32(ddlDivision.SelectedValue.ToString());
objParameter.ParameterCode = txtParameterCode.Text.Trim();
objParameter.ParameterDesc = txtParameterDesc.Text.Trim();
objParameter.ActionBy = Membership.GetUser().UserName.ToString();
objParameter.ActiveFlag = rdoStatus.SelectedValue.ToString();
objParameter.ActionType = "INSERT_PARAMETERMASTER";
objParameter.SaveParameterMaster();
if (objParameter.ReturnValue == -1)
{
//MESSAGE AT ERROR IN STORED PROCEDURE
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
//MESSAGE IF RECORD ALREADY EXIST
if (objParameter.MessageOut == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DulplicateRecord, SIMSenuMessageType.UserMessage, false, "");
}
//MESSAGE AT INSERTION
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.AddRecord, SIMSenuMessageType.UserMessage, false, "");
ClearControls();
}
}
}
catch (Exception ex)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
finally
{
objCommonClass.BindDataGrid(gvComm, "uspParameterMaster", true, sqlParamSrh, lblRowCount);
//BindGrid();
ClearControls();
}
}
//******ADDED BY Mahesh************//
private void FillDropDownToolTip()
{
try
{
if (ddlSpareCode != null)
{
for (int k = 0; k < ddlSpareCode.Items.Count; k++)
{
ddlSpareCode.Items[k].Attributes.Add("title", ddlSpareCode.Items[k].Text);
}
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
objVendor.Vendor_Code = txtVendorCode.Text.Trim();
objVendor.Vendor_Name = txtVendorName.Text.Trim();
objVendor.Address = txtAddress.Text.Trim();
objVendor.EmpCode = Membership.GetUser().UserName.ToString();
objVendor.ActiveFlag = rdoStatus.SelectedValue.ToString();
// added 4 july bhawesh
if (ddlBranch.SelectedIndex != 0)
{
objVendor.Branch_ID = Convert.ToInt32(ddlBranch.SelectedValue);
}
else
{
objVendor.Branch_ID = 0;
}
string strMsg = objVendor.SaveData("INSERT_VENDOR");
if (objVendor.ReturnValue == -1)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
if (strMsg == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ActivateStatusNotChange, SIMSenuMessageType.UserMessage, false, "");
}
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.RecordUpdated, SIMSenuMessageType.UserMessage, false, "");
}
}
}
catch (Exception ex)
{
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
objCommonClass.BindDataGrid(gvComm, "uspVendorMaster", true, sqlParamSrh, lblRowCount);
ClearControls();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
objCommonMIS.EmpId = Membership.GetUser().UserName.ToString();
objCommonMIS.BusinessLine_Sno = "2";
objCommonMIS.RegionSno = "0";
objCommonMIS.BranchSno = "0";
if (!Page.IsPostBack)
{
objASCSparePurchaseOutside.RegionSno = "0";
objASCSparePurchaseOutside.UserName = Membership.GetUser().UserName.ToString();
objASCSparePurchaseOutside.GetUserRegions(ddlRegion);
objASCSparePurchaseOutside.GetUserBranchs(ddlBranch);
if (objCommonMIS.CheckLoogedInASC() > 0)
{
objCommonMIS.GetSCs(ddlASC);
if (ddlASC.Items.Count == 2)
{
ddlASC.SelectedIndex = 1;
}
}
else
{
objCommonMIS.GetUserSCs(ddlASC);
if (ddlASC.Items.Count == 2)
{
ddlASC.SelectedIndex = 1;
}
}
objASCSparePurchaseOutside.ProductDivision_Id = 0;
// objASCSparePurchaseOutside.GetAllProductDivision(ddlProductDivison);
objCommonClass.SelectASC_Name_Code(Membership.GetUser().UserName.ToString());
ddlRegion_SelectedIndexChanged(ddlRegion, null);
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void imgBtnGo_Click(object sender, EventArgs e)
{
try
{
if (gvComm.PageIndex != -1)
{
gvComm.PageIndex = 0;
}
sqlParamSrh[1].Value = ddlSearch.SelectedValue.ToString();
sqlParamSrh[2].Value = txtSearch.Text.Trim();
objCommonClass.BindDataGrid(gvComm, "uspFGIntermediate", true, sqlParamSrh, lblRowCount);
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
try
{
Page.Validate("NewBill");
if (Page.IsValid)
{
lblMessage.Text = "";
trRecordCount.Visible = true;
BindGridView();
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void ddlBranch_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
objCommonMIS.RegionSno = ddlRegion.SelectedValue;
objCommonMIS.BranchSno = ddlBranch.SelectedValue;
objCommonMIS.GetUserSCs(ddlASC);
if (ddlASC.Items.Count == 2)
{
ddlASC.SelectedIndex = 1;
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
//end
protected void imgBtnAdd_Click(object sender, EventArgs e)
{
try
{
//Assigning values to properties
objFGIntermediateScreen.ProductSNo = 0;
objFGIntermediateScreen.ProductCode = ddlProduct.SelectedValue.ToString();
string[] Product_Desc = ddlProduct.SelectedItem.ToString().Split('(');
foreach (string prod_desc in Product_Desc)
{
objFGIntermediateScreen.ProductDesc = prod_desc.ToString().Trim();
break;
}
objFGIntermediateScreen.ProductGroup_SNo = int.Parse(ddlProductGroup.SelectedValue.ToString());
objFGIntermediateScreen.Rating_Status = ddlRating.SelectedValue.ToString();
objFGIntermediateScreen.EmpCode = Membership.GetUser().UserName.ToString();
objFGIntermediateScreen.ActiveFlag = rdoStatus.SelectedValue.ToString();
//Calling SaveData to save Product details and pass type "INSERT_PRODUCT" it return "" if record
//is not already exist otherwise exists
string strMsg = objFGIntermediateScreen.SaveData("INSERT_PRODUCT");
if (objFGIntermediateScreen.ReturnValue == -1)
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.ErrorInStoreProc, SIMSenuMessageType.Error, false, "");
}
else
{
if (strMsg == "Exists")
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.DulplicateRecord, SIMSenuMessageType.UserMessage, false, "");
}
else
{
lblMessage.Text = SIMSCommonClass.getErrorWarrning(SIMSenuErrorWarrning.AddRecord, SIMSenuMessageType.UserMessage, false, "");
}
}
}
catch (Exception ex)
{
//Writing Error message to File using SIMSCommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
objCommonClass.BindDataGrid(gvComm, "uspFGIntermediate", true, sqlParamSrh, lblRowCount);
objFGIntermediateScreen.BindDDLProduct(ddlProduct);
ClearControls();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
objdefspareconfirm.CGuser = Membership.GetUser().UserName.ToString();
objdefspareconfirm.BindASC(ddlASC);
objdefspareconfirm.ASC = ddlASC.SelectedValue;
objdefspareconfirm.BindDivision(ddlDivision);
ddlDivision_SelectedIndexChanged(null, null);
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
//added by arun:29/12/2010
private DataTable GetActivityGrid(int ActivityParameter_SNo)
{
DataTable dt = new DataTable();
try
{
objspareconsumeforcomplaint.Complaint_No = lblComplaintNo.Text;
objspareconsumeforcomplaint.ProductDivision_Id = Convert.ToInt32(hdnProductDivision_Id.Value);
objspareconsumeforcomplaint.ASC_Id = Convert.ToInt32(hdnASC_Id.Value);
objspareconsumeforcomplaint.ActivityParameter_SNo = ActivityParameter_SNo;
dt = objspareconsumeforcomplaint.getActivityGridDataCheckBox();
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
return(dt);
}
private void FillActivityGrid()
{
try
{
objspareconsumeforcomplaint.Complaint_No = lblComplaintNo.Text;
objspareconsumeforcomplaint.ProductDivision_Id = Convert.ToInt32(hdnProductDivision_Id.Value);
objspareconsumeforcomplaint.ASC_Id = Convert.ToInt32(hdnASC_Id.Value);
DataTable dt = objspareconsumeforcomplaint.getActivityGridData();
//added by sandeep: 29/12/2010
ViewState["tempdt"] = dt;
gvActivityCharges.DataSource = dt;
gvActivityCharges.DataBind();
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void gvChallanDetail_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
gvChallanDetail.PageIndex = e.NewPageIndex;
ObjSpareServiceActivity.ProductDiv = ddlDivision.SelectedValue;
ObjSpareServiceActivity.ASC = ddlASC.SelectedValue;
DataSet ds = new DataSet();
ds = ObjSpareServiceActivity.BindData();
lblRowCount.Text = Convert.ToString(ds.Tables[0].Rows.Count);
gvChallanDetail.DataSource = ds;
gvChallanDetail.DataBind();
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
foreach (GridViewRow row in gvConfirmation.Rows)
{
CheckBox ActivityConfirm = (CheckBox)row.FindControl("chkActivityConfirm");
TextBox Comment = (TextBox)row.FindControl("txtComment");
Label lblComment = (Label)row.FindControl("lblComment");
if (ActivityConfirm.Checked)
{
if (string.IsNullOrEmpty(Comment.Text))
{
lblComment.Text = "Enter Comment.";
return;
}
}
}
foreach (GridViewRow row in gvConfirmation.Rows)
{
HiddenField hdnLabelcomplaint = (HiddenField)row.FindControl("hdnLabelcomplaint");
CheckBox chkcomplaintConfirm = (CheckBox)row.FindControl("chkActivityConfirm");
TextBox txtComment = (TextBox)row.FindControl("txtComment");
if (chkcomplaintConfirm.Checked)
{
objSpareRequirementComplaint.ComplaintNo = hdnLabelcomplaint.Value;
objSpareRequirementComplaint.Comment = txtComment.Text.Trim();
objSpareRequirementComplaint.ApproveComplaint();
if (objSpareRequirementComplaint.MessageOut == "")
{
BindgvConfirmation();
}
}
}
}
catch (Exception ex)
{
SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
