/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Constrctor to update selected area
/// </summary>
public FrmAreaItem(FrmArea frmArea, Area pArea)
: this()
{
mfrmArea = frmArea;
mArea = pArea;
//mOldArea = System.Clo
mblnUpdate = true;
this.Text = "Cap nhat khu vuc";
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Delete 1 area with area_id
/// </summary>
/// <param name="pArea">Area</param>
public int Delete(Area pArea)
{
IDbDataParameter[] parameters = {
MakeParameter("@Area_ID", DbType.Int32, 10)
};
parameters[0].Value = pArea.AreaID;
int rowAffected = 0;
RunProcedure("sp_ADV_AREA_DELETE", parameters, out rowAffected);
return rowAffected;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Create new area and return area id auto increment
/// </summary>
/// <param name="pArea">Area</param>
public int Create(Area pArea)
{
IDbDataParameter[] parameters = {
MakeParameter("@Code", DbType.String, 10),
MakeParameter("@Name", DbType.String, 200),
};
parameters[0].Value = pArea.Code;
parameters[1].Value = pArea.Name;
int rowAffected = 0;
return RunProcedure("sp_ADV_AREA_INSERT", parameters, out rowAffected);
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Process add area in UI
/// </summary>
/// <param name="pArea">Area</param>
public void AddAreaUI(Area pArea)
{
// Add row to grid
DataRow row = ((DataView)mdgrArea.DataSource).Table.NewRow();
row["AREA_ID"] = pArea.AreaID;
row["CODE"] = pArea.Code;
row["NAME"] = pArea.Name;
row["##STT##"] = mdgrArea.Rows.Count + 1;
((DataView)mdgrArea.DataSource).Table.Rows.Add(row);
// change current row to last row
mdgrArea.CurrentCell = mdgrArea.Rows[mdgrArea.RowCount - 1].Cells[0];
mdgrArea.CurrentRow.Selected = true;
SetButtonStatus();
//GenSTT();
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Delete 1 area with area_id
/// </summary>
public int Delete(Area pArea)
{
PrArea area = new PrArea(Connection);
int intRowAffected = 0;
try
{
Open();
intRowAffected = area.Delete(pArea);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return intRowAffected;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Insert 1 area and return area_id auto increment
/// </summary>
public int Add(Area pArea)
{
PrArea area = new PrArea(Connection);
int intAreaID = -1;
try
{
Open();
intAreaID = area.Create(pArea);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return intAreaID;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Retrieves all area
/// </summary>
public DataSet Retrieves(Area pArea)
{
PrArea area = new PrArea(Connection);
try
{
Open();
return area.Search(pArea);
}
catch (Exception exp)
{
throw exp;
}
finally
{
Close();
}
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Get current area from grid
/// </summary>
/// <param name="return">Area</param>
public Area GetCurrentArea()
{
// Get current row data into area
Area area = new Area();
area.Name = (String)mdgrArea.CurrentRow.Cells["NAME"].Value;
area.Code = (String)mdgrArea.CurrentRow.Cells["CODE"].Value;
area.AreaID = ((Int32)mdgrArea.CurrentRow.Cells["AREA_ID"].Value);
// Return
return area;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: make search param depend on combo box
/// </summary>
private Area MakeSearchParam()
{
Area area = new Area();
area.AreaID = -1;
area.Code = (mcboSearch.SelectedIndex == 1) ? mtxtSearch.Text.Trim() : null;
area.Name = (mcboSearch.SelectedIndex == 2) ? mtxtSearch.Text.Trim() : null;
return area;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Update new area in UI
/// </summary>
/// <param name="pArea">Area</param>
public void UpdateAreaUI(Area pArea)
{
// Update from data to row in grid
mdgrArea.CurrentRow.Cells["NAME"].Value = pArea.Name;
mdgrArea.CurrentRow.Cells["CODE"].Value = pArea.Code;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Update 1 area with area_id
/// </summary>
/// <param name="pArea">Area</param>
public int Update(Area pArea)
{
IDbDataParameter[] parameters = {
MakeParameter("@Area_ID", DbType.Int32, 10),
MakeParameter("@Code", DbType.String, 10),
MakeParameter("@Name", DbType.String, 200),
};
parameters[0].Value = pArea.AreaID;
parameters[1].Value = pArea.Code;
parameters[2].Value = pArea.Name;
int rowAffected = 0;
RunProcedure("sp_ADV_AREA_UPDATE", parameters, out rowAffected);
return rowAffected;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Searh all area
/// </summary>
public DataSet Search(Area pArea)
{
IDbDataParameter[] parameters = {
MakeParameter("@Area_ID", DbType.Int32, 10),
MakeParameter("@Code", DbType.String, 10),
MakeParameter("@Name", DbType.String, 200)
};
parameters[0].Value = (pArea.AreaID < 0) ? (object) DBNull.Value : (object) pArea.AreaID;
parameters[1].Value = (pArea.Code == null) ? (object) DBNull.Value : (object)pArea.Code;
parameters[2].Value = (pArea.Name == null) ? (object) DBNull.Value : (object)pArea.Name;
return RunProcedure("sp_ADV_AREA_SELECT_SEARCH", parameters, "ADV_AREA");
}