//public DataTable GetRegistrationIdAndParentCode()
//{
// DataTable dt = new DataTable();
// string query = @"Select Registration_ID,Parent_Code From SBP_Parent_Child_Registration order by Registration_ID desc";
// try
// {
// _dbconnection.ConnectDatabase();
// dt = _dbconnection.ExecuteQuery(query);
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// _dbconnection.CloseDatabase();
// }
// return dt;
//}
public void InsertParentChildRegistrationInfo(ParentChildRegistrationBO bo)
{
string arrayJoin = "";
if (bo.Child_Code != null)
{
arrayJoin = string.Join(",", bo.Child_Code);
}
string query = @"InsertParentChildRegistrationInfo";
try
{
_dbconnection.ConnectDatabase();
_dbconnection.ActiveStoredProcedure();
if (bo.Registration_Image != null)
{
_dbconnection.AddParameter("@RegImage", SqlDbType.Image, bo.Registration_Image);
}
else
{
_dbconnection.AddParameter("@RegImage", SqlDbType.Image, DBNull.Value);
}
_dbconnection.AddParameter("@EntryByName", SqlDbType.VarChar, bo.UserName);
_dbconnection.AddParameter("@parentCode", SqlDbType.VarChar, bo.Parent_Code);
//_dbconnection.AddParameter("@ChildCode", SqlDbType.VarChar, arrayJoin);
_dbconnection.ExecuteProQuery(query);
}
catch (Exception ex)
{
//throw ex;
}
}
/// <summary>
/// Update Registration Image and owner info
/// Rashedul Hasan 2015 sep 03
/// </summary>
/// <param name="bo">Parent Child Registration's image update</param>
/// <param name="P_Bo">Owner Name cell email gender</param>
public void Update_Parent_Registration_Image(ParentChildRegistrationBO bo, ParentAndChildBO P_Bo)
{
string query = "SBP_Update_ParentChildInfo";
try
{
_dbconnection.ConnectDatabase();
// _dbconnection.ActiveStoredProcedure();
if (bo.Registration_Image != null)
{
_dbconnection.AddParameter("@Registration_Image", SqlDbType.Image, bo.Registration_Image);
}
else
{
_dbconnection.AddParameter("@Registration_Image", SqlDbType.Image, DBNull.Value);
}
_dbconnection.AddParameter("@Update_By", SqlDbType.VarChar, GlobalVariableBO._userName);
if (string.IsNullOrEmpty(bo.Parent_Code))
{
_dbconnection.AddParameter("@Parent_Code", SqlDbType.VarChar, DBNull.Value);
}
else
{
_dbconnection.AddParameter("@Parent_Code", SqlDbType.VarChar, bo.Parent_Code);
}
if (string.IsNullOrEmpty(P_Bo.Owner_cell))
{
_dbconnection.AddParameter("@Hadeler_Contact_Mobile", SqlDbType.VarChar, P_Bo.Owner_cell);
}
else
{
_dbconnection.AddParameter("@Hadeler_Contact_Mobile", SqlDbType.VarChar, P_Bo.Owner_cell);
}
if (string.IsNullOrEmpty(P_Bo.Owner_Email_1))
{
_dbconnection.AddParameter("@Handeler_Email_1", SqlDbType.VarChar, DBNull.Value);
}
else
{
_dbconnection.AddParameter("@Handeler_Email_1", SqlDbType.VarChar, P_Bo.Owner_Email_1);
}
if (string.IsNullOrEmpty(P_Bo.Parent_Gender))
{
_dbconnection.AddParameter("@Hadeler_Gender", SqlDbType.VarChar, DBNull.Value);
}
else
{
_dbconnection.AddParameter("@Hadeler_Gender", SqlDbType.VarChar, P_Bo.Parent_Gender);
}
if (string.IsNullOrEmpty(P_Bo.Parent_Name))
{
_dbconnection.AddParameter("@Handeler_Parent_Name", SqlDbType.VarChar, DBNull.Value);
}
else
{
_dbconnection.AddParameter("@Handeler_Parent_Name", SqlDbType.VarChar, P_Bo.Parent_Name);
}
_dbconnection.ExecuteProQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
