public void Update(ClientShareholderInfo info) { if (!this.isSubTable) { db.Open(); } string query = " UPDATE [dbo].[ClientShareholder] SET " + " [RowNo] = @RowNo " + ", [Name] = @Name " + ", [NoOfShares] = @NoOfShares " + ", [Nationality] = @Nationality " + ", [IdentityNo] = @IdentityNo " + ", [ContactNo] = @ContactNo " + ", [Address] = @Address " + ", [CreateDate] = @CreateDate " + ", [CreateUser] = @CreateUser " + ", [LastModifiedDate] = @LastModifiedDate " + ", [LastModifiedUser] = @LastModifiedUser " + " where ClientID = @ClientID and RowNo = @RowNo "; db.Execute(query, info, this.transaction); if (!this.isSubTable) { db.Close(); } }
public void Save(ClientShareholderInfo info) { if (this.IsExisted(info)) { this.Update(info); } else { this.Insert(info); } }
public void UpdateClientShareholder(ClientShareholderInfo clientShareholderInfo) { string query = "UPDATE [dbo].[ClientShareholder] " + "SET " + " [ShareholderName] = @ShareholderName " + ",[NoOfShares] = @NoOfShares " + ",[LastModifiedUser] = @LastModifiedUser " + ",[LastModifiedDate] = @LastModifiedDate " + "WHERE ClientID = @ClientID and RowNo = @RowNo "; db.Execute(query, clientShareholderInfo, transaction); }
public bool IsExisted(ClientShareholderInfo info) { if (!this.isSubTable) { db.Open(); } String query = "select count(*) from ClientShareholder " + " where ClientID = @ClientID and RowNo = @RowNo"; var obj = (List <int>)db.Query <int>(query, info, this.transaction); if (!this.isSubTable) { db.Close(); } return(obj[0] > 0); }
public void Insert(ClientShareholderInfo info) { if (!this.isSubTable) { db.Open(); } string query = "INSERT INTO [dbo].[ClientShareholder] ( [ClientID] " + ",[RowNo] " + ",[Name] " + ",[NoOfShares] " + ",[Nationality] " + ",[IdentityNo] " + ",[ContactNo] " + ",[Address] " + ",[CreateDate] " + ",[CreateUser] " + ",[LastModifiedDate] " + ",[LastModifiedUser] " + ") " + "VALUES ( @ClientID " + ",@RowNo " + ",@Name " + ",@NoOfShares " + ",@Nationality " + ",@IdentityNo " + ",@ContactNo " + ",@Address " + ",@CreateDate " + ",@CreateUser " + ",@LastModifiedDate " + ",@LastModifiedUser " + ") "; db.Execute(query, info, this.transaction); if (!this.isSubTable) { db.Close(); } }
public void InsertClientShareholder(ClientShareholderInfo clientShareholderInfo) { string query = "INSERT INTO [dbo].[ClientShareholder] " + "([ClientID] " + ",[RowNo] " + ",[ShareholderName] " + ",[NoOfShares] " + ",[CreateUser] " + ",[CreateDate] " + ",[LastModifiedUser] " + ",[LastModifiedDate] ) " + "VALUES " + "(@ClientID " + ",@RowNo" + ",@ShareholderName " + ",@NoOfShares " + ",@CreateUser " + ",@CreateDate " + ",@LastModifiedUser " + ",@LastModifiedDate) "; db.Execute(query, clientShareholderInfo, transaction); }