protected void GridTask_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridTask.Rows[e.RowIndex]; Label lblID = (Label)row.FindControl("lblID"); // Label lblID = (Label)row.FindControl("Label1"); int ID = Convert.ToInt32(lblID.Text); TextBox txtTergetQty = ((TextBox)row.FindControl("txtTergetQty")); TextBox txtSchedule_Date = ((TextBox)row.FindControl("txtSchedule_Date")); TextBox txtRemarks = ((TextBox)row.FindControl("txtRemarks")); TextBox txtComments = ((TextBox)row.FindControl("txtComments")); MRK_Task_Details aMRK_Task_Details = new MRK_Task_Details(); aMRK_Task_Details.WorkOrderId = Convert.ToInt32(HiddenFieldworkOrderId.Value); DateTime?nullabledate = null; aMRK_Task_Details.Date = txtSchedule_Date.Text == "" ? nullabledate : Convert.ToDateTime(txtSchedule_Date.Text); aMRK_Task_Details.Remarks = txtRemarks.Text; aMRK_Task_Details.Comments = txtComments.Text; aMRK_Task_Details.EditDate = DateTime.Today; aMRK_Task_Details.EditUser = ((SessionUser)Session["SessionUser"]).UserId; aMRK_Task_Details.OCode = ((SessionUser)Session["SessionUser"]).OCode; int result1 = aVisitStatusUpdateBLL.UpdateTaskDetails(aMRK_Task_Details, ID); if (result1 == 1) { //GridTask.EditIndex = -1; //LoadTaskDetails(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true); } }
internal int UpdateTaskDetails(MRK_Task_Details aMRK_Task_Details, int ID) { try { using (var _context = new ERPSSL_Marketing_Entities()) { var TaskDetails = _context.MRK_Task_Details.FirstOrDefault(x => x.TaskDetails_Id == ID); TaskDetails.Date = aMRK_Task_Details.Date; TaskDetails.Remarks = aMRK_Task_Details.Remarks; TaskDetails.Comments = aMRK_Task_Details.Comments; TaskDetails.EditDate = aMRK_Task_Details.EditDate; TaskDetails.EditUser = aMRK_Task_Details.EditUser; _context.SaveChanges(); return(1); } } catch (Exception) { throw; } }
protected void saveButton_Click(object sender, EventArgs e) { try { if (saveButton.Text == "Submit") { if (handoverStatusDropDownList.Text == "--Select--") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Handover Status')", true); } else if (warrentyPeriodTextBox.Text == null) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Input Warranty Period (Months)')", true); } else if (handoverStatusDropDownList.Text != "--Select--") { if (handoverStatusDropDownList.Text == "Yes") { handoverConditins = true; } else if (handoverStatusDropDownList.Text == "No") { handoverConditins = false; } MRK_WorkOrder aMRK_WorkOrder = new MRK_WorkOrder(); aMRK_WorkOrder.MarketingInfoId = Convert.ToInt32(HidMarketingInfoId.Value); aMRK_WorkOrder.WorkOrderDate = Convert.ToDateTime(workOrderDateTextBox.Text); aMRK_WorkOrder.CompletionPeriod = workCompletionPeriodTextBox.Text; aMRK_WorkOrder.ProposedAmount = Convert.ToDecimal(proposedAmountTextBox.Text); aMRK_WorkOrder.SigningAmount = Convert.ToDecimal(signingAmountTextBox.Text); aMRK_WorkOrder.RemainingAmount = Convert.ToDecimal(remainingAmountTextBox.Text); aMRK_WorkOrder.PaymentCondition = paymentConditionTextBox.Text; aMRK_WorkOrder.AMC_Condition = amcConditionTextBox.Text; aMRK_WorkOrder.DevelopmentDept = developmentDepartmentTextBox.Text; aMRK_WorkOrder.HandoverStatus = handoverConditins; aMRK_WorkOrder.Remarks = remarksTextBox.Text; aMRK_WorkOrder.WarrantyPeriod = Convert.ToInt32(warrentyPeriodTextBox.Text); aMRK_WorkOrder.AMCDAte = Convert.ToDateTime(amcDateTextBox.Text); aMRK_WorkOrder.Create_User = ((SessionUser)Session["SessionUser"]).UserId; aMRK_WorkOrder.Create_Date = DateTime.Now; aMRK_WorkOrder.OCODE = ((SessionUser)Session["SessionUser"]).OCode; int result = aWorkOrderDetailsBLL.SaveWorkOrderInfo(aMRK_WorkOrder); MRK_Transaction aMRK_Transaction = new MRK_Transaction(); aMRK_Transaction.WorkOrderId = result; aMRK_Transaction.CollectionDate = Convert.ToDateTime(workOrderDateTextBox.Text); aMRK_Transaction.CollectionAmount = Convert.ToDecimal(signingAmountTextBox.Text); aMRK_Transaction.Remarks = remarksTextBox.Text; aMRK_Transaction.Create_User = ((SessionUser)Session["SessionUser"]).UserId; aMRK_Transaction.Create_Date = DateTime.Now; aMRK_Transaction.OCODE = ((SessionUser)Session["SessionUser"]).OCode; int result2 = aWorkOrderDetailsBLL.SaveWorkOrderToTransaction(aMRK_Transaction); List <LC_InputType> inputTypeList = new List <LC_InputType>(); inputTypeList = aWorkOrderDetailsBLL.GetAllTask(); foreach (LC_InputType typeList in inputTypeList) { MRK_Task_Details aMRK_Task_Details = new MRK_Task_Details(); aMRK_Task_Details.WorkOrderId = (int)result; aMRK_Task_Details.Remarks = ""; aMRK_Task_Details.Comments = ""; aMRK_Task_Details.Date = DateTime.Now; aMRK_Task_Details.Task = typeList.Input_Name; aMRK_Task_Details.Create_User = ((SessionUser)Session["SessionUser"]).UserId; aMRK_Task_Details.Create_Date = DateTime.Now; aMRK_Task_Details.OCode = ((SessionUser)Session["SessionUser"]).OCode; _context.MRK_Task_Details.AddObject(aMRK_Task_Details); _context.SaveChanges(); } if (result2 == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); } } } else if (saveButton.Text == "Update") { if (handoverStatusDropDownList.Text == "--Select--") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Handover Status')", true); } else if (handoverStatusDropDownList.Text != "--Select--") { if (handoverStatusDropDownList.Text == "Yes") { handoverConditins = true; } else if (handoverStatusDropDownList.Text == "No") { handoverConditins = false; } MRK_WorkOrder aMRK_WorkOrder = new MRK_WorkOrder(); aMRK_WorkOrder.MarketingInfoId = Convert.ToInt32(HidMarketingInfoId.Value); aMRK_WorkOrder.WorkOrderDate = Convert.ToDateTime(workOrderDateTextBox.Text); aMRK_WorkOrder.CompletionPeriod = workCompletionPeriodTextBox.Text; aMRK_WorkOrder.ProposedAmount = Convert.ToDecimal(proposedAmountTextBox.Text); aMRK_WorkOrder.SigningAmount = Convert.ToDecimal(signingAmountTextBox.Text); aMRK_WorkOrder.RemainingAmount = Convert.ToDecimal(remainingAmountTextBox.Text); aMRK_WorkOrder.Remarks = remarksTextBox.Text; aMRK_WorkOrder.PaymentCondition = paymentConditionTextBox.Text; aMRK_WorkOrder.AMC_Condition = amcConditionTextBox.Text; aMRK_WorkOrder.DevelopmentDept = developmentDepartmentTextBox.Text; aMRK_WorkOrder.HandoverStatus = handoverConditins; aMRK_WorkOrder.WarrantyPeriod = Convert.ToInt32(warrentyPeriodTextBox.Text); aMRK_WorkOrder.AMCDAte = Convert.ToDateTime(amcDateTextBox.Text); aMRK_WorkOrder.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; aMRK_WorkOrder.Edit_Date = DateTime.Now; aMRK_WorkOrder.OCODE = ((SessionUser)Session["SessionUser"]).OCode; int workOrderId = Convert.ToInt16(HiddenFieldWorkOrderId.Value); int result = aWorkOrderDetailsBLL.UpdateWorkOrderInfo(aMRK_WorkOrder, workOrderId); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true); } } } ClearAllControl(); GetWorkOrderDetailsForGridView(); } catch (Exception ex) { string EID = Convert.ToString(((SessionUser)Session["SessionUser"]).EID); //LogController<officeSetup>.SetLog(ex, EID); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } GetWorkOrderDetailsForGridView(); }
internal int UpdateTaskDetails(MRK_Task_Details aMRK_Task_Details, int ID) { return(aVisitStatusUpdateDAL.UpdateTaskDetails(aMRK_Task_Details, ID)); }
protected void clientNameTextBox_TextChanged(object sender, EventArgs e) { if (availableList == 0) { } else { try { string OCode = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode); string clientName = clientNameTextBox.Text; MarketingProjectStage aMarketingProjectStage = aVisitStatusUpdateBLL.GetInvidualMarketingInfoList(OCode, clientName); if (aMarketingProjectStage != null) { HidMarketingInfoId.Value = aMarketingProjectStage.MarketingInfoId.ToString(); visitDateTextBox.Text = aMarketingProjectStage.VisitDate.ToString("MM/dd/yyyy"); //clientNameTextBox.Text = aMarketingProjectStage.Client.ToString(); contactPersonTextBox.Text = aMarketingProjectStage.ContactPerson.ToString(); designationTextBox.Text = aMarketingProjectStage.Designation.ToString(); contactNumberTextBox.Text = aMarketingProjectStage.ContactNumber.ToString(); emailTextBox.Text = aMarketingProjectStage.Email.ToString(); addressTextBox.Text = aMarketingProjectStage.Address.ToString(); projectTextBox.Text = aMarketingProjectStage.ProjectName.ToString(); moduleTextBox.Text = aMarketingProjectStage.Module.ToString(); marketingPersonTextBox.Text = aMarketingProjectStage.MArketingPersonName.ToString(); referenceTextBox.Text = aMarketingProjectStage.ReferenceName.ToString(); remarksTextBox.Text = aMarketingProjectStage.Remarks.ToString(); stageTextBox.Text = aMarketingProjectStage.StageName.ToString(); } // Finding WorkId of Marketing Info int marketingInfoId = Convert.ToInt32(HidMarketingInfoId.Value); //int workOrderId = aVisitStatusUpdateBLL.GetWorkOrderId(marketingInfoId); //if (workOrderId != 0) //{ // Check WorkId At Task Details Table List <int> taskIdList = new List <int>(); taskIdList = aVisitStatusUpdateBLL.getTaskIdList(marketingInfoId); if (taskIdList.Count == 0) { List <LC_InputType> inputTypeList = new List <LC_InputType>(); inputTypeList = aVisitStatusUpdateBLL.GetAllTask(); foreach (LC_InputType typeList in inputTypeList) { MRK_Task_Details aMRK_Task_Details = new MRK_Task_Details(); aMRK_Task_Details.WorkOrderId = marketingInfoId; aMRK_Task_Details.Remarks = ""; aMRK_Task_Details.Comments = ""; aMRK_Task_Details.Date = DateTime.Now; aMRK_Task_Details.Task = typeList.Input_Name; aMRK_Task_Details.Create_User = ((SessionUser)Session["SessionUser"]).UserId; aMRK_Task_Details.Create_Date = DateTime.Now; aMRK_Task_Details.OCode = ((SessionUser)Session["SessionUser"]).OCode; _context.MRK_Task_Details.AddObject(aMRK_Task_Details); _context.SaveChanges(); } LoadTaskToGrid(); } else { LoadTaskToGrid(); } //} //else //{ // GridTask.DataSource = null; //} } catch (Exception ex) { throw ex; } } }