private void AssetMovementReportBtn_Click(object sender, EventArgs e)
{
frmAssetMovementReport rpt = new frmAssetMovementReport();
rpt.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้อยู่ตรงกลาง
rpt.Asset_Sys = strAssetMovementId;
rpt.ShowDialog();
}
private void CreateAsset_Btn_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure to movement asset " + txtAssetNo.Text.Trim() + " yes/no?", "Asset Management Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
Tr = Conn.BeginTransaction();
try
{
string sqlSaveStHead;
Sbd = new StringBuilder();
Sbd.Remove(0, Sbd.Length);
Sbd.Append("UPDATE Asset ");
Sbd.Append("SET Owner = @To_Owner,");
Sbd.Append("Base = @To_Base,");
Sbd.Append("Location = @To_Location,");
Sbd.Append("Asset_Status = @To_Status, ");
Sbd.Append("Modified_By = @Modified_By, ");
Sbd.Append("Modified_Date = @Modified_Date, ");
Sbd.Append("Amend = @Amend ");
Sbd.Append("WHERE Asset_No_System = @Asset_No_System");
sqlSaveStHead = Sbd.ToString();
Cmd.Parameters.Clear();
Cmd.Transaction = Tr;
Cmd.CommandText = sqlSaveStHead;
Cmd.Parameters.Add("@To_Owner", SqlDbType.NChar).Value = cboOwner.SelectedValue.ToString();
Cmd.Parameters.Add("@To_Base", SqlDbType.NChar).Value = cboBase.SelectedValue.ToString();
Cmd.Parameters.Add("@To_Location", SqlDbType.NChar).Value = cboLocation.SelectedValue.ToString();
Cmd.Parameters.Add("@To_Status", SqlDbType.NChar).Value = cboStatus.SelectedValue.ToString();
Cmd.Parameters.Add("@Asset_No_System", SqlDbType.NVarChar).Value = txt_Sys_Asset.Text.Trim();
Cmd.Parameters.Add("@Modified_Date", SqlDbType.DateTime).Value = DateTime.Now;
Cmd.Parameters.Add("@Modified_By", SqlDbType.NChar).Value = userId;
Cmd.Parameters.Add("@Amend", SqlDbType.Int).Value = Convert.ToInt64(txtAmend.Text.Trim()) + 1;
Cmd.ExecuteNonQuery();
// Insert to movement for first time created asset
Sbd = new StringBuilder();
Sbd.Remove(0, Sbd.Length);
Sbd.Append("INSERT INTO Asset_Movement ");
Sbd.Append("(Asset_Movement_Id,");
Sbd.Append("Asset_No_System,");
Sbd.Append("Asset_No,");
Sbd.Append("Fixed_Asset_No,");
Sbd.Append("From_Owner,");
Sbd.Append("From_Base,");
Sbd.Append("From_Location,");
Sbd.Append("From_Status,");
Sbd.Append("Remarks,");
Sbd.Append("MovementDate,");
Sbd.Append("Movement_By,");
Sbd.Append("To_Owner,");
Sbd.Append("To_Base,");
Sbd.Append("To_Location,");
Sbd.Append("To_Status,");
Sbd.Append("RequestBy,");
Sbd.Append("Asste_Move_RunId) ");
Sbd.Append("VALUES ");
Sbd.Append("(@Asset_Movement_Id,");
Sbd.Append("@Asset_No_System,");
Sbd.Append("@Asset_No,");
Sbd.Append("@Fixed_Asset_No,");
Sbd.Append("@From_Owner,");
Sbd.Append("@From_Base,");
Sbd.Append("@From_Location,");
Sbd.Append("@From_Status,");
Sbd.Append("@Remarks,");
Sbd.Append("@MovementDate,");
Sbd.Append("@Movement_By,");
Sbd.Append("@To_Owner,");
Sbd.Append("@To_Base,");
Sbd.Append("@To_Location,");
Sbd.Append("@To_Status,");
Sbd.Append("@RequestBy,");
Sbd.Append("@Asste_Move_RunId) ");
sqlSaveStHead = Sbd.ToString();
Cmd.Parameters.Clear();
Cmd.Transaction = Tr;
Cmd.CommandText = sqlSaveStHead;
Cmd.Parameters.Add("@Asset_Movement_Id", SqlDbType.NVarChar).Value = txtAssetMovementId.Text.Trim();
Cmd.Parameters.Add("@Asset_No_System", SqlDbType.NVarChar).Value = txt_Sys_Asset.Text.Trim();
Cmd.Parameters.Add("@Asset_No", SqlDbType.NVarChar).Value = txtAssetNo.Text.Trim();
Cmd.Parameters.Add("@Fixed_Asset_No", SqlDbType.NVarChar).Value = txtFixAssetNo.Text.Trim();
Cmd.Parameters.Add("@From_Owner", SqlDbType.NChar).Value = cboOwner.SelectedValue.ToString();
Cmd.Parameters.Add("@From_Base", SqlDbType.NChar).Value = cboBase.SelectedValue.ToString();
Cmd.Parameters.Add("@From_Location", SqlDbType.NChar).Value = cboLocation.SelectedValue.ToString();
Cmd.Parameters.Add("@From_Status", SqlDbType.NChar).Value = cboStatus.SelectedValue.ToString();
Cmd.Parameters.Add("@To_Owner", SqlDbType.NChar).Value = cboOwner.SelectedValue.ToString();
Cmd.Parameters.Add("@To_Base", SqlDbType.NChar).Value = cboBase.SelectedValue.ToString();
Cmd.Parameters.Add("@To_Location", SqlDbType.NChar).Value = cboLocation.SelectedValue.ToString();
Cmd.Parameters.Add("@To_Status", SqlDbType.NChar).Value = cboStatus.SelectedValue.ToString();
Cmd.Parameters.Add("@Remarks", SqlDbType.NVarChar).Value = txtRemarksForMoveTo.Text.Trim();
Cmd.Parameters.Add("@MovementDate", SqlDbType.DateTime).Value = DateTime.Now;
Cmd.Parameters.Add("@Movement_By", SqlDbType.NChar).Value = userId;
Cmd.Parameters.Add("@Asste_Move_RunId", SqlDbType.Int).Value = AssetMovementId;
Cmd.Parameters.Add("@RequestBy", SqlDbType.NChar).Value = cboRequestBy.SelectedValue.ToString();
Cmd.ExecuteNonQuery();
MessageBox.Show("Record asset successfully", "Asset Management Message", MessageBoxButtons.OK, MessageBoxIcon.None);
Tr.Commit();
DialogResult dlg = MessageBox.Show("ต้องการพิมพ์ เอกสาร Asset Movement หรือไม่!!!", "ผลการทำงาน", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlg == DialogResult.OK)
{
frmAssetMovementReport rpt = new frmAssetMovementReport();
rpt.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้อยู่ตรงกลาง
rpt.Asset_Sys = txt_Sys_Asset.Text.Trim();
rpt.ShowDialog();
}
Close();
}
catch (Exception ex)
{
MessageBox.Show("Unable to record asset" + ex.Message, "Asset Management Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Tr.Rollback();
}
}
}
