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;
}
}
}
