public void Update(PositionDetails Details)
{
try
{
string SQL = "CALL procPositionUpdate(@PositionID, @PositionCode, @PositionName);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@PositionID", Details.PositionID);
cmd.Parameters.AddWithValue("@PositionCode", Details.PositionCode);
cmd.Parameters.AddWithValue("@PositionName", Details.PositionName);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int16 Insert(PositionDetails Details)
{
try
{
string SQL = "CALL procPositionInsert(@PositionCode, @PositionName);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmPositionCode = new MySqlParameter("@PositionCode",MySqlDbType.String);
prmPositionCode.Value = Details.PositionCode;
cmd.Parameters.Add(prmPositionCode);
MySqlParameter prmPositionName = new MySqlParameter("@PositionName",MySqlDbType.String);
prmPositionName.Value = Details.PositionName;
cmd.Parameters.Add(prmPositionName);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int16 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int16.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int16 Insert(PositionDetails Details)
{
try
{
string SQL = "CALL procPositionInsert(@PositionCode, @PositionName);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmPositionCode = new MySqlParameter("@PositionCode", MySqlDbType.String);
prmPositionCode.Value = Details.PositionCode;
cmd.Parameters.Add(prmPositionCode);
MySqlParameter prmPositionName = new MySqlParameter("@PositionName", MySqlDbType.String);
prmPositionName.Value = Details.PositionName;
cmd.Parameters.Add(prmPositionName);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int16 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int16.Parse(dr[0].ToString());
}
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PositionDetails Details(string PositionName)
{
try
{
string SQL = SQLSelect() + "WHERE PositionName = @PositionName;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@PositionName", PositionName);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
PositionDetails Details = new PositionDetails();
while (myReader.Read())
{
Details.PositionID = myReader.GetInt16("PositionID");
Details.PositionCode = "" + myReader["PositionCode"].ToString();
Details.PositionName = "" + myReader["PositionName"].ToString();
}
myReader.Close();
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(PositionDetails Details)
{
try
{
string SQL = "CALL procSavePositions(@PositionID, @PositionCode, @PositionName, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("PositionID", Details.PositionID);
cmd.Parameters.AddWithValue("PositionCode", Details.PositionCode);
cmd.Parameters.AddWithValue("PositionName", Details.PositionName);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PositionDetails Details(string PositionName)
{
try
{
string SQL= SQLSelect() + "WHERE PositionName = @PositionName;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@PositionName", PositionName);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
PositionDetails Details = new PositionDetails();
while (myReader.Read())
{
Details.PositionID = myReader.GetInt16("PositionID");
Details.PositionCode = "" + myReader["PositionCode"].ToString();
Details.PositionName = "" + myReader["PositionName"].ToString();
}
myReader.Close();
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(PositionDetails Details)
{
try
{
string SQL = "CALL procSavePositions(@PositionID, @PositionCode, @PositionName, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("PositionID", Details.PositionID);
cmd.Parameters.AddWithValue("PositionCode", Details.PositionCode);
cmd.Parameters.AddWithValue("PositionName", Details.PositionName);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(PositionDetails Details)
{
try
{
string SQL = "CALL procPositionUpdate(@PositionID, @PositionCode, @PositionName);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@PositionID", Details.PositionID);
cmd.Parameters.AddWithValue("@PositionCode", Details.PositionCode);
cmd.Parameters.AddWithValue("@PositionName", Details.PositionName);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private Int16 SaveRecord()
{
Positions clsPosition = new Positions();
PositionDetails clsDetails = new PositionDetails();
clsDetails.PositionCode = txtPositionCode.Text;
clsDetails.PositionName = txtPositionName.Text;
Int16 id = clsPosition.Insert(clsDetails);
clsPosition.CommitAndDispose();
return id;
}
private void SaveRecord()
{
Positions clsPosition = new Positions();
PositionDetails clsDetails = new PositionDetails();
clsDetails.PositionID = Convert.ToInt16(lblPositionID.Text);
clsDetails.PositionCode = txtPositionCode.Text;
clsDetails.PositionName = txtPositionName.Text;
clsPosition.Update(clsDetails);
clsPosition.CommitAndDispose();
}