public static List <ATTUnit> GetUnitList(string status, bool containDefault)
{
List <ATTUnit> lst = new List <ATTUnit>();
try
{
DataTable tbl = DLLUnit.GetUnitTable(status);
foreach (DataRow row in tbl.Rows)
{
ATTUnit unit = new ATTUnit();
unit.UnitID = int.Parse(row["Unit_id"].ToString());
unit.UnitName = row["Unit_name"].ToString();
unit.UnitAddress = row["Unit_Address"].ToString();
unit.UnitPhone = row["Unit_Phone"].ToString();
unit.Active = row["active"].ToString();
unit.Action = "N";
lst.Add(unit);
}
if (lst.Count > 0 && containDefault == true)
{
ATTUnit def = new ATTUnit();
def.UnitID = -1;
def.UnitName = "छान्नुहोस्";
lst.Insert(0, def);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddUnit(ATTUnit unit)
{
try
{
return(DLLUnit.AddUnit(unit));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddUnit(ATTUnit unit)
{
string SP = "";
if (unit.Action == "A")
{
SP = "sp_add_units";
}
else if (unit.Action == "E")
{
SP = "sp_edit_units";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam("P_UNIT_ID", unit.UnitID, OracleDbType.Int16, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam("P_UNIT_NAME", unit.UnitName, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_UNIT_ADDRESS", unit.UnitAddress, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_UNIT_PHONE", unit.UnitPhone, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_ACTIVE", unit.Active, OracleDbType.Varchar2, ParameterDirection.Input));
GetConnection DBConn = new GetConnection();
try
{
OracleConnection Conn = DBConn.GetDbConn(Module.LJMS);
SqlHelper.ExecuteNonQuery(Conn, CommandType.StoredProcedure, SP, paramArray.ToArray());
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DBConn.CloseDbConn();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.txtName_Rqd.Text == "")
{
this.lblStatusMessage.Text = "Please enter unit name.";
this.programmaticModalPopup.Show();
return;
}
if (this.txtAddress_Rqd.Text == "")
{
this.lblStatusMessage.Text = "Please enter unit address.";
this.programmaticModalPopup.Show();
return;
}
if (this.txtPhone_Rqd.Text == "")
{
this.lblStatusMessage.Text = "Please enter unit phone number.";
this.programmaticModalPopup.Show();
return;
}
ATTUnit unit = new ATTUnit();
unit.UnitID = 0;
unit.UnitName = this.txtName_Rqd.Text;
unit.UnitAddress = this.txtAddress_Rqd.Text;
unit.UnitPhone = this.txtPhone_Rqd.Text;
unit.Active = this.cnkActive.Checked == true ? "Y" : "N";
unit.Action = "A";
if (this.grdUnit.SelectedIndex >= 0)
{
unit.UnitID = int.Parse(this.grdUnit.SelectedRow.Cells[0].Text);
unit.Action = "E";
}
if (this.grdUnit.SelectedIndex < 0)
{
if (this.User.MenuList[this.MenuName] == null || this.User.MenuList[this.MenuName].PAdd == "N")
{
string s = Utilities.PreviledgeMsg + " add lawyer unit.";
this.ShowMessage(null, s);
return;
}
}
else
{
if (this.User.MenuList[this.MenuName] == null || this.User.MenuList[this.MenuName].PEdit == "N")
{
string s = Utilities.PreviledgeMsg + " edit lawyer unit.";
this.ShowMessage(null, s);
return;
}
}
try
{
BLLUnit.AddUnit(unit);
this.Clear();
this.LoadUnit();
this.lblStatusMessage.Text = "Unit has been saved successfully.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
