public void UpdateParentChildOwnerDetails(ParentAndChildBO bo)
{
string updateQuery = @"UPDATE [SBP_Database].[dbo].[SBP_Parent_Child_Owner_Details]
SET [Parent_Id] = '" + bo.Parent_Code + @"'
,[Handeler_BOID] = '" + bo.Owner_boid + @"'
,[Handeler_Parent_Name] = '" + bo.Owner_name + @"'
,[Hadeler_Gender] = '" + bo.Owner_gender + @"'
,[Hadeler_Contact_Mobile] = '" + bo.Owner_cell + @"'
,[Handeler_Contact_Land] = '" + bo.Owner_land + @"'
,[Handeler_Email_1] = '" + bo.Owner_email + @"'
,[Handeler_Email_2] = '" + bo.Owner_Email_1 + @"'
,[Handeler_Email_3] = '" + bo.Owner_Email_2 + @"'
,[Handelr_Occupation] = '" + bo.Owner_profession + @"'
,[Handeler_Present_Address] = '" + bo.Owner_present_addr + @"'
,[Handeler_Permanent_Address] = '" + bo.Owner_permanent_add + @"'
,[Update_By]='" + GlobalVariableBO._userName + @"'
,[Update_Date]=GetDate()
WHERE [Parent_Id]='" + bo.Parent_Code + "'";
try
{
_dbconnection.ConnectDatabase();
_dbconnection.ExecuteNonQuery(updateQuery);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbconnection.CloseDatabase();
}
}
public void SaveOwnerInfo(ParentAndChildBO pBo, int RegistrationId)
{
string query = @"InserOwnerDetailsInfo";
try
{
_dbconnection.ConnectDatabase();
_dbconnection.ActiveStoredProcedure();
_dbconnection.AddParameter("@Registration_Id ", SqlDbType.Int, RegistrationId);
_dbconnection.AddParameter("@Parent_Id", SqlDbType.Int, pBo.Parent_Code);
_dbconnection.AddParameter("@Handeler_Parent_Name", SqlDbType.VarChar, pBo.Owner_name);
_dbconnection.AddParameter("@Hadeler_Gender", SqlDbType.VarChar, pBo.Owner_gender);
_dbconnection.AddParameter("@Hadeler_Contact_Mobile", SqlDbType.VarChar, pBo.Owner_cell);
_dbconnection.AddParameter("@Handeler_Contact_Land", SqlDbType.VarChar, pBo.Owner_land);
_dbconnection.AddParameter("@Handeler_Email_1", SqlDbType.VarChar, pBo.Owner_email);
_dbconnection.AddParameter("@Handeler_Email_2", SqlDbType.VarChar, pBo.Owner_Email_1);
_dbconnection.AddParameter("@Handeler_Email_3", SqlDbType.VarChar, pBo.Owner_Email_2);
_dbconnection.AddParameter("@Handelr_Occupation", SqlDbType.VarChar, pBo.Owner_profession);
_dbconnection.AddParameter("@Handeler_Present_Address", SqlDbType.VarChar, pBo.Owner_present_addr);
_dbconnection.AddParameter("@Handeler_Permanent_Address", SqlDbType.VarChar, pBo.Owner_permanent_add);
_dbconnection.AddParameter("@Entry_By", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbconnection.ExecuteProQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbconnection.CloseDatabase();
}
}
public void SaveParentInfo(ParentAndChildBO pBo)
{
CommonBAL com = new CommonBAL();
string query = @"INSERT INTO [SBP_Parent_Child_Details]
(
Parent_Code
,[Child_Code]
,[Child_BOID]
,[Handeler_Name]
,[Parent_Name]
,[Parent_Gender]
,[Parent_Profession]
,[Parent_Email]
,[Parent_Contact_Mobile]
,[Parent_Contact_Land]
,[Parent_Address_Present]
,[Parent_Address_Permanet]
,[Entry_By]
,[Entry_Date])
VALUES
('" + pBo.Parent_Code + "','"
+ pBo.Child_Code + "','"
+ pBo.Chil_BoId + "','"
+ com.HandlingSingelQuation(pBo.Handeler_Name) + "','"
+ com.HandlingSingelQuation(pBo.Parent_Name) + "','"
+ com.HandlingSingelQuation(pBo.Parent_Gender) + "','"
+ com.HandlingSingelQuation(pBo.Parent_Profession) + "','"
+ com.HandlingSingelQuation(pBo.parent_Email) + "','"
+ pBo.Parent_Cell + "','"
+ pBo.parent_land + "','"
+ com.HandlingSingelQuation(pBo.Parent_Present_addr) + "','"
+ com.HandlingSingelQuation(pBo.parent_Permanent_add) + "','"
+ com.HandlingSingelQuation(GlobalVariableBO._userName) + "',"
+ ("getdate()") + ")";
try
{
_dbconnection.ConnectDatabase();
_dbconnection.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbconnection.CloseDatabase();
}
}
/// <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;
}
}
