public static int DeletePart(int partId) { partModel data = new partModel { partId = partId }; string sql = @"delete from [Part] where partId = @partId;"; return(SqlDataAccess.SaveData(sql, data)); }
public static int CreatePart(string partName, int side) { partModel data = new partModel { partName = partName, side = side }; string sql = @"insert into [part] (partName,side) values (@partName,@side);"; return(SqlDataAccess.SaveData(sql, data)); }
public static int updatePart(int partId, string partName, int side) { partModel data = new partModel { partId = partId, partName = partName, side = side }; string sql = @"update [Part] set partName=@partName,side=@side where partId=@partId ;"; return(SqlDataAccess.SaveData(sql, data)); }
public static List <partModel> getPartName(int partId) { partModel data = new partModel { partId = partId }; string sql = @"select partName from [Part] where partId=@partId;"; return(SqlDataAccess.LoadData <partModel>(sql, data)); }
public static List <partModel> getPartIdByName(string partName, int side) { partModel data = new partModel { partName = partName, side = side }; string sql = @"select partId from [Part] where partName=@partName and side = @side;"; return(SqlDataAccess.LoadData <partModel>(sql, data)); }