public void Update(DataTypeContent myEntity)
{
SQLDAHelper SqlHelper = new SQLDAHelper();
SqlConnection conn = SqlHelper.GetConnection(false);
SqlHelper.AddInParameter("@data_type_content_id", SqlDbType.Int,myEntity.DataTypeContentId);
SqlHelper.AddInParameter("@data_type_content", SqlDbType.NVarChar, myEntity.DataTypeContents);
SqlHelper.AddInParameter("@data_type_content_ar", SqlDbType.NVarChar, myEntity.DataTypeContentAr);
SqlHelper.AddInParameter("@data_type_id", SqlDbType.Int, myEntity.DataTypeId);
SqlHelper.AddInParameter("@updated_by", SqlDbType.Int, myEntity.UpdatedBy);
SqlHelper.ExecuteNonQuery("dbo.SP_DataTypeContent_Update", conn, false);
}
public void Add(DataTypeContent myEntity)
{
SQLDAHelper SqlHelper = new SQLDAHelper();
SqlConnection conn = SqlHelper.GetConnection(false);
SqlHelper.AddOutParameter("@data_type_content_id", SqlDbType.Int);
SqlHelper.AddInParameter("@data_type_content", SqlDbType.NVarChar,myEntity.DataTypeContents );
SqlHelper.AddInParameter("@data_type_content_ar", SqlDbType.NVarChar, myEntity.DataTypeContentAr);
SqlHelper.AddInParameter("@data_type_id", SqlDbType.Int, myEntity.DataTypeId);
SqlHelper.AddInParameter("@created_by", SqlDbType.Int, myEntity.CreatedBy);
SqlHelper.ExecuteNonQuery("dbo.SP_DataTypeContent_Add", conn, false);
myEntity.DataTypeContentId = (int)SqlHelper.GetOutParameterValue("@data_type_content_id");
}
public E.DataTypeContent GetMapper(SqlDataReader reader)
{
E.DataTypeContent DataTypeContentObj = new E.DataTypeContent();
if (reader["data_type_content_id"]!= DBNull.Value){DataTypeContentObj.DataTypeContentId =(int)reader["data_type_content_id"];}
if (reader["data_type_content"]!= DBNull.Value){DataTypeContentObj.DataTypeContents =(string)reader["data_type_content"];}
if (reader["data_type_content_ar"]!= DBNull.Value){DataTypeContentObj.DataTypeContentAr =(string)reader["data_type_content_ar"];}
if (reader["data_type_id"]!= DBNull.Value){DataTypeContentObj.DataTypeId =(int)reader["data_type_id"];}
if (reader["flag_deleted"]!= DBNull.Value){DataTypeContentObj.FlagDeleted =(bool)reader["flag_deleted"];}
if (reader["is_system"]!= DBNull.Value){DataTypeContentObj.IsSystem =(bool)reader["is_system"];}
if (reader["created_by"]!= DBNull.Value){DataTypeContentObj.CreatedBy =(int)reader["created_by"];}
if (reader["updated_by"]!= DBNull.Value){DataTypeContentObj.UpdatedBy =(int)reader["updated_by"];}
if (reader["created_date"]!= DBNull.Value){DataTypeContentObj.CreatedDate =(DateTime)reader["created_date"];}
if (reader["updated_date"]!= DBNull.Value){DataTypeContentObj.UpdatedDate =(DateTime)reader["updated_date"];}
return DataTypeContentObj;
}
