public Int32 Insert(AccessGroupDetails Details) { try { // Aug 2, 2014 : change to save only Details.CreatedOn = Details.CreatedOn == Constants.C_DATE_MIN_VALUE ? DateTime.Now : Details.CreatedOn; Details.LastModified = Details.LastModified == Constants.C_DATE_MIN_VALUE ? DateTime.Now : Details.LastModified; Save(Details); string SQL = "INSERT INTO sysAccessGroups (GroupName, Remarks) VALUES (@GroupName, @Remarks);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; //MySqlParameter prmGroupName = new MySqlParameter("@GroupName",MySqlDbType.String); //prmGroupName.Value = Details.GroupName; //cmd.Parameters.Add(prmGroupName); //MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String); //prmRemarks.Value = Details.Remarks; //cmd.Parameters.Add(prmRemarks); //base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int32 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int32.Parse(dr[0].ToString()); } return(iID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Insert(AccessGroupDetails Details) { try { // Aug 2, 2014 : change to save only Details.CreatedOn = Details.CreatedOn == Constants.C_DATE_MIN_VALUE ? DateTime.Now : Details.CreatedOn; Details.LastModified = Details.LastModified == Constants.C_DATE_MIN_VALUE ? DateTime.Now : Details.LastModified; Save(Details); string SQL = "INSERT INTO sysAccessGroups (GroupName, Remarks) VALUES (@GroupName, @Remarks);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; //MySqlParameter prmGroupName = new MySqlParameter("@GroupName",MySqlDbType.String); //prmGroupName.Value = Details.GroupName; //cmd.Parameters.Add(prmGroupName); //MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String); //prmRemarks.Value = Details.Remarks; //cmd.Parameters.Add(prmRemarks); //base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int32 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int32.Parse(dr[0].ToString()); } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
public AccessGroupDetails Details(Int32 GroupID) { try { string SQL = "SELECT " + "GroupID, " + "GroupName, " + "Remarks " + "FROM sysAccessGroups " + "WHERE GroupID = @GroupID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmGroupID = new MySqlParameter("@GroupID", MySqlDbType.Int16); prmGroupID.Value = GroupID; cmd.Parameters.Add(prmGroupID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); AccessGroupDetails Details = new AccessGroupDetails(); while (myReader.Read()) { Details.GroupID = GroupID; Details.GroupName = "" + myReader["GroupName"].ToString(); Details.Remarks = "" + myReader["Remarks"].ToString(); } myReader.Close(); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(AccessGroupDetails Details) { try { // Aug 2, 2014 : change to save only Details.CreatedOn = Details.CreatedOn == Constants.C_DATE_MIN_VALUE ? DateTime.Now : Details.CreatedOn; Details.LastModified = Details.LastModified == Constants.C_DATE_MIN_VALUE ? DateTime.Now : Details.LastModified; Save(Details); //string SQL= "UPDATE sysAccessGroups SET " + // "GroupName = @GroupName," + // "Remarks = @Remarks " + // "WHERE GroupID = @GroupID;"; //MySqlCommand cmd = new MySqlCommand(); //cmd.CommandType = System.Data.CommandType.Text; //cmd.CommandText = SQL; //MySqlParameter prmGroupName = new MySqlParameter("@GroupName",MySqlDbType.String); //prmGroupName.Value = Details.GroupName; //cmd.Parameters.Add(prmGroupName); //MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String); //prmRemarks.Value = Details.Remarks; //cmd.Parameters.Add(prmRemarks); //MySqlParameter prmGroupID = new MySqlParameter("@GroupID",MySqlDbType.Int16); //prmGroupID.Value = Details.GroupID; //cmd.Parameters.Add(prmGroupID); //base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(AccessGroupDetails Details) { try { string SQL = "CALL procSaveSysAccessGroups(@GroupID, @GroupName, @Remarks, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("GroupID", Details.GroupID); cmd.Parameters.AddWithValue("GroupName", Details.GroupName); cmd.Parameters.AddWithValue("Remarks", Details.Remarks); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public AccessGroupDetails Details(Int32 GroupID) { try { string SQL= "SELECT " + "GroupID, " + "GroupName, " + "Remarks " + "FROM sysAccessGroups " + "WHERE GroupID = @GroupID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmGroupID = new MySqlParameter("@GroupID",MySqlDbType.Int16); prmGroupID.Value = GroupID; cmd.Parameters.Add(prmGroupID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); AccessGroupDetails Details = new AccessGroupDetails(); while (myReader.Read()) { Details.GroupID = GroupID; Details.GroupName = "" + myReader["GroupName"].ToString(); Details.Remarks = "" + myReader["Remarks"].ToString(); } myReader.Close(); return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(AccessGroupDetails Details) { try { string SQL = "CALL procSaveSysAccessGroups(@GroupID, @GroupName, @Remarks, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("GroupID", Details.GroupID); cmd.Parameters.AddWithValue("GroupName", Details.GroupName); cmd.Parameters.AddWithValue("Remarks", Details.Remarks); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(AccessGroupDetails Details) { try { // Aug 2, 2014 : change to save only Details.CreatedOn = Details.CreatedOn == Constants.C_DATE_MIN_VALUE ? DateTime.Now : Details.CreatedOn; Details.LastModified = Details.LastModified == Constants.C_DATE_MIN_VALUE ? DateTime.Now : Details.LastModified; Save(Details); //string SQL= "UPDATE sysAccessGroups SET " + // "GroupName = @GroupName," + // "Remarks = @Remarks " + // "WHERE GroupID = @GroupID;"; //MySqlCommand cmd = new MySqlCommand(); //cmd.CommandType = System.Data.CommandType.Text; //cmd.CommandText = SQL; //MySqlParameter prmGroupName = new MySqlParameter("@GroupName",MySqlDbType.String); //prmGroupName.Value = Details.GroupName; //cmd.Parameters.Add(prmGroupName); //MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String); //prmRemarks.Value = Details.Remarks; //cmd.Parameters.Add(prmRemarks); //MySqlParameter prmGroupID = new MySqlParameter("@GroupID",MySqlDbType.Int16); //prmGroupID.Value = Details.GroupID; //cmd.Parameters.Add(prmGroupID); //base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }