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);
}
