public void DeletePositionRecord_B(PositionRecord obj) { StringBuilder sql = new StringBuilder(); sql = SqlBuilder.Delete(obj); List<SqlParameter> parameter = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@PositionRecord_ID",Value = obj.PositionRecord_ID} }; ConnectDBToSendData(sql, parameter); }
public void CreatePositionRecord_B(PositionRecord obj) { StringBuilder sql = new StringBuilder(); sql = SqlBuilder.Insert(obj); List<SqlParameter> parameter = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@Member_ID",Value = obj.Member_ID}, new SqlParameter() {ParameterName = "@Position_ID",Value = obj.Position_ID}, new SqlParameter() {ParameterName = "@PositionRecord_Enddate",Value = obj.PositionRecord_Enddate}, new SqlParameter() {ParameterName = "@PositionRecord_Startdate",Value = obj.PositionRecord_Startdate} }; ConnectDBToSendData(sql, parameter); }
public object UpdatePositionRecorddata_B(PositionRecord objPara) { BPRModel.UpdatePositionRecord_B(objPara); object objData = true; return objData; }