/********************************************************************************************************/
public SCT_PSA getPersonnelSubArea_DAL()
{
logger.Info("Method : getPersonnelSubArea_DAL Start");
databaseLayer dbConStr = new databaseLayer();
string connStr = dbConStr.connectionInfo;
logger.Debug("Connection string : " + connStr);
SqlConnection conn = new SqlConnection(connStr);
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
logger.Debug("Connection Status opened ");
}
logger.Info("Connetion to the database established");
try
{
string query = "select code sa_id,codedescription sa_desc from codes where codetype='personnelsubarea' and displayorder=1";
SqlCommand cmd_SCTDetails = new SqlCommand();
cmd_SCTDetails.Connection = conn;
cmd_SCTDetails.CommandText = query;
logger.Info("cmd_SCTDetails Query parameters initialised");
QueryLog.CmdInfo(cmd_SCTDetails);
SqlDataAdapter da_SCTDetails = new SqlDataAdapter();
da_SCTDetails.SelectCommand = cmd_SCTDetails;
DataSet dSet_SCTDetails = new DataSet();
da_SCTDetails.Fill(dSet_SCTDetails);
logger.Info("cmd_SCTDetails excuted by SqlDataAdapter()");
int Details_count = dSet_SCTDetails.Tables[0].Rows.Count;
logger.DebugFormat("Row Count : ItemDetails table {0}", Details_count.ToString());
SCT_PSA result = new SCT_PSA(Details_count);
if (Details_count > 0)
{
result.SCT_header.StatusFlag = 0;
result.SCT_header.StatusMsg = SCT_Constants.Success;
int objCounter_item = 0;
foreach (DataRow item_dr in dSet_SCTDetails.Tables[0].Rows)
{
SCT_PSA.PSA Item = new SCT_PSA.PSA();
Item.ID = item_dr["SA_ID"].ToString();
Item.Label = item_dr["SA_DESC"].ToString();
result.SCT_Details[objCounter_item++] = Item;
}
}
else
{
result.SCT_header.StatusFlag = 1;
result.SCT_header.StatusMsg = "No records Found";
}
logger.Info("Method : searchEmployee_DAL Stop");
return result;
}
catch (SqlException dbEx)
{
logger.Fatal("Exception Occured At SCT_DAL - getPersonnelSubArea_DAL");
logger.Debug("Exception Code : " + dbEx.Number.ToString());
logger.Debug("Exception Description : " + dbEx.Message.ToString());
logger.Error("Error : getPersonnelSubArea_DAL Stop");
throw dbEx;
}
catch (Exception ex)
{
logger.Fatal("Exception Occured At SCT_DAL - getPersonnelSubArea_DAL : " + ex.Message.ToString());
logger.Error("Error : getPersonnelSubArea_DAL Stop");
throw ex;
}
finally
{
logger.Debug("Connection Status Closed ");
conn.Dispose();
}
}
public SCT_PSA getPersonnelSubArea()
{
logger.Info("Method : getPersonnelSubArea Start");
try
{
SCT_PSA result = new SCT_PSA();
SCTInterface PSA_SI = new SCTInterface();
result = PSA_SI.getPersonnelSubArea_SI();
logger.Info("Method : getPersonnelSubArea Stop");
return result;
}
catch (SqlException ex)
{
webServiceExHandling.ExceptionLog(ex);
//string mailBody = string.Format(SCT_Constants.mail_BodyFormat,System.DateTime.Now.ToString("F"),PReqNo,ex.TargetSite.ToString(),ex.ToString());
//webServiceExHandling.Send_Email(SCT_Constants.Email_Dic, mailBody);
SCT_PSA Error = new SCT_PSA();
Error.SCT_header.StatusFlag = ex.Number;
string expCode = ExpType(ex);
Error.SCT_header.StatusMsg = SCT_Constants.cnfgErrMessages[expCode];
logger.Debug("Return object Error : Status Flag = " + Error.SCT_header.StatusFlag.ToString());
logger.Debug("Return object Error : Status Message = " + Error.SCT_header.StatusMsg);
logger.Error("Method : getPersonnelSubArea Stop");
return Error;
}
catch (Exception ex)
{
webServiceExHandling.ExceptionLog(ex);
//string mailBody = string.Format(SCT_Constants.mail_BodyFormat, System.DateTime.Now.ToString("F"), PReqNo, ex.TargetSite.ToString(), ex.ToString());
//webServiceExHandling.Send_Email(SCT_Constants.Email_Dic, mailBody);
SCT_PSA Error = new SCT_PSA();
Error.SCT_header.StatusFlag = 1;
Error.SCT_header.StatusMsg = SCT_Constants.Error;
logger.Debug("Return object Error : ErrorCode = " + Error.SCT_header.StatusFlag.ToString());
logger.Debug("Return object Error : ErrorMessage = " + Error.SCT_header.StatusMsg);
logger.Error("Method : getPersonnelSubArea Stop");
return Error;
}
}