public void GetMachineComplaintsAndRectifiedDetails() { bmcr = new BMachineComplaintsAndRectifiedRecord(); DataSet DS = new DataSet(); DS = bmcr.GetMachineComplaintsAndRectifiedDetails(); if (!Comman.Comman.IsDataSetEmpty(DS)) { rpMachineComplaintsReport.DataSource = DS; rpMachineComplaintsReport.DataBind(); } }
public void GetMachineComplaintsAndRectifiedDetails(int MachineComplaintsAndRectifiedRecordId) { DataSet DS = new DataSet(); bmcr = new BMachineComplaintsAndRectifiedRecord(); DS = bmcr.GetMachineComplaintsAndRectifiedDetailsById(MachineComplaintsAndRectifiedRecordId); if (!Comman.Comman.IsDataSetEmpty(DS)) { string DATE = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MachineComplaintsAndRectifiedRecordDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MachineComplaintsAndRectifiedRecordDate"].ToString(); if (DATE == "") { txtComplaintsDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd")); } else { DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat); txtComplaintsDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd")); } dpShiftDetails.ClearSelection(); if (dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MachineComplaintsAndRectifiedRecordShiftId"]).ToString()) != null) { dpShiftDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MachineComplaintsAndRectifiedRecordShiftId"]).ToString()).Selected = true; } txtMachineName.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MachineName"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MachineName"].ToString(); txtIdentifiedBy.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["IdentifiedBy"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["IdentifiedBy"].ToString(); txtRectifiedBy.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["RectifiedBy"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["RectifiedBy"].ToString(); string DATE2 = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["RectifiedDate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["RectifiedDate"].ToString(); if (DATE2 == "") { txtRectifiedDate.Text = Convert.ToString(DateTime.Now.ToString("yyy-MM-dd")); } else { DateTime date1 = Convert.ToDateTime(DATE, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat); txtRectifiedDate.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd")); } dpStatusDetails.ClearSelection(); if (dpStatusDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MachineRectifiedStatus"]).ToString()) != null) { dpStatusDetails.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["MachineRectifiedStatus"]).ToString()).Selected = true; } } }
protected void btnUpdate_Click(object sender, EventArgs e) { { mmcr = new MMachineComplaintsAndRectifiedRecord(); bmcr = new BMachineComplaintsAndRectifiedRecord(); int Result = 0; mmcr.MachineComplaintsAndRectifiedRecordId = string.IsNullOrEmpty(hId.Value) ? 0 : Convert.ToInt32(hId.Value); mmcr.MachineComplaintsAndRectifiedRecordDate = Convert.ToDateTime(txtComplaintsDate.Text.ToString()); mmcr.MachineComplaintsAndRectifiedRecordShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); mmcr.MachineName = txtMachineName.Text; mmcr.IdentifiedBy = txtIdentifiedBy.Text; mmcr.RectifiedBy = txtRectifiedBy.Text; mmcr.RectifiedDate = Convert.ToDateTime(txtRectifiedDate.Text.ToString()); mmcr.MachineRectifiedStatus = Convert.ToInt32(dpStatusDetails.SelectedItem.Value); mmcr.flag = "Update"; Result = bmcr.machinereportdata(mmcr); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Machine Complaints And Rectified Data Update Successfully"; pnlError.Update(); // GetPastDetails(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblSuccess.Text = "Something went wrong plz contact site admin"; pnlError.Update(); } //return Result; } }
protected void btnAdd_Click(object sender, EventArgs e) { { mmcr = new MMachineComplaintsAndRectifiedRecord(); bmcr = new BMachineComplaintsAndRectifiedRecord(); int Result = 0; mmcr.MachineComplaintsAndRectifiedRecordId = 0; mmcr.MachineComplaintsAndRectifiedRecordDate = Convert.ToDateTime(txtComplaintsDate.Text.ToString()); mmcr.MachineComplaintsAndRectifiedRecordShiftId = Convert.ToInt32(dpShiftDetails.SelectedItem.Value); mmcr.MachineName = txtMachineName.Text; mmcr.IdentifiedBy = txtIdentifiedBy.Text; mmcr.RectifiedBy = txtRectifiedBy.Text; mmcr.RectifiedDate = Convert.ToDateTime(txtRectifiedDate.Text.ToString()); mmcr.MachineRectifiedStatus = Convert.ToInt32(dpStatusDetails.SelectedItem.Value); mmcr.flag = "Insert"; Result = bmcr.machinereportdata(mmcr); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Machine Complaints And Rectified Data Add Successfully"; pnlError.Update(); ScriptManager.RegisterStartupScript(this, this.GetType(), "sel3", "$('#bx1').removeClass('collapsed-box');", true); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblSuccess.Text = "Something went wrong plz contact site admin"; pnlError.Update(); } //return Result; } }