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();
}
}
