private void InsUpdDelSetup(string value, char Event, int id)
{
var msg = "";
if ((value == "Dg") && (Event == 'I' || Event == 'U'))
{
var objDesignation = new Designation(id, txtDesignation.Text);
msg = BL_Staff.InsUpdDelDesignation(Event, objDesignation, out id);
}
else if ((value == "Dp") && (Event == 'I' || Event == 'U'))
{
var objDepartment = new Department(id, txtDepartment.Text);
msg = BL_Staff.InsUpdDelDepartment(Event, objDepartment, out id);
}
else if ((value == "Aq") && (Event == 'I' || Event == 'U'))
{
var objQualification = new AcedamicQualification(id, txtAcedamicQualification.Text);
msg = BL_Staff.InsUpdDelAcedamicQualification(Event, objQualification, out id);
}
else if ((value == "St") && (Event == 'I' || Event == 'U'))
{
var objServiceType = new ServiceType(id, txtServiceType.Text);
msg = BL_Staff.InsUpdDelService(Event, objServiceType, out id);
}
else if ((value == "Eg") && (Event == 'I' || Event == 'U'))
{
var objEthnicGroup = new EthnicGroup(id, txtEthnicGroup.Text, 1, "XX");
msg = BL_Staff.InsUpdDelEthnicGroup(Event, objEthnicGroup, out id);
}
if (DatabaseMessage.ContainMessage(msg))
{
_msgbox.ShowSuccess(msg);
}
else
{
_msgbox.ShowWarning(msg);
}
// FillGridview();
// ClearAll();
}
public static string InsUpdDelAcedamicQualification(char Event, AcedamicQualification obj, out int returnId)
{
returnId = 0;
try
{
var cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "USP_IUD_tbl_Acedamic_Qualification";
cmd.Connection = DL_CCommon.ConnectionForCommonDb();
cmd.Parameters.AddWithValue("@EVENT", Event);
cmd.Parameters.AddWithValue("@Id", obj.Id);
cmd.Parameters.AddWithValue("@Qualification", obj.Qualification);
var outparameter = new SqlParameter("@MSG", SqlDbType.NVarChar, 200)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(outparameter);
var outId = new SqlParameter("@RETURNOUTID", SqlDbType.NVarChar, 100)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(outId);
cmd.ExecuteNonQuery();
var msg = cmd.Parameters[outparameter.ParameterName].Value;
returnId = Convert.ToInt32(cmd.Parameters[outId.ParameterName].Value);
return(Convert.ToString(msg));
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
finally
{
DL_CCommon.ConnectionForCommonDb().Close();
}
}
public static string InsUpdDelAcedamicQualification(char Event, AcedamicQualification obj, out int id)
{
id = 0;
return(DlStaffinfo.InsUpdDelAcedamicQualification(Event, obj, out id));
}
