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