public override bool UpdateDrawingType(DrawingType drawingType)
 {
     using (SqlConnection cn = new SqlConnection(LayerObjectsConnection))
     {
         SqlCommand cmd = new SqlCommand("DrawingTypes_UpdateDrawingType", cn);
         //cmd.Parameters.Add("@Id", SqlDbType.NVarChar).Value = drawingType.Id;
         //cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = drawingType.Name;
         //cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = drawingType.Phone;
         //cmd.Parameters.Add("@StateId", SqlDbType.Int).Value = drawingType.ItemState;
         cn.Open();
         int ret = ExecuteNonQuery(cmd);
         return(ret == 1);
     }
 }
Example #2
0
        protected virtual DrawingType GetDrawingTypeFromReader(IDataReader reader)
        {
            DrawingType drawingType = new DrawingType()
            {
                Id      = (Guid)reader["Id"],
                Caption = reader["Caption"].ToString()
            };

            if (reader["Code"] != DBNull.Value)
            {
                drawingType.Code = reader["Code"].ToString();
            }
            return(drawingType);
        }
 public override int InsertDrawingType(DrawingType drawingType)
 {
     using (SqlConnection cn = new SqlConnection(LayerObjectsConnection))
     {
         SqlCommand cmd = new SqlCommand("DrawingTypes_InsertDrawingType", cn);
         cmd.CommandType = CommandType.Text;
         //cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = drawingType.Name;
         //cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = drawingType.Phone;
         //cmd.Parameters.Add("@StateId", SqlDbType.Int).Value = drawingType.ItemState;
         cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
         cn.Open();
         int ret = ExecuteNonQuery(cmd);
         return((int)cmd.Parameters["@Id"].Value);
     }
 }
Example #4
0
 public abstract bool UpdateDrawingType(DrawingType drawingType);
Example #5
0
 public abstract int InsertDrawingType(DrawingType drawingType);