private PackageLimitDTO getpackageDTO()
{
PackageLimitDTO sign = new PackageLimitDTO();
int id = 0;
Int32.TryParse(hdfId.Value + "", out id);
sign.limitId = id;
sign.namepackagelimit = txtnamepackagelimit.Text;
if (!ceUnLimit.Checked)
sign.under = Int32.Parse(txtunder.Text);
sign.cost = float.Parse(txtcode.Text);
sign.isUnLimit = ceUnLimit.Checked;
sign.isActive = ceIsActive.Checked;
return sign;
}
public void tblPackageLimit_Update(PackageLimitDTO dt)
{
string sql = "UPDATE tblPackageLimit SET " +
"namepackagelimit= @namepackagelimit, " +
"under = @under, " +
"cost = @cost, " +
"isActive = @isActive, " +
"isUnlimit = @IsUnLimit " +
" WHERE limitId = @limitId";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@namepackagelimit", SqlDbType.NVarChar).Value = dt.namepackagelimit;
cmd.Parameters.Add("@under", SqlDbType.BigInt).Value = dt.under;
cmd.Parameters.Add("@cost", SqlDbType.Float).Value = dt.cost;
cmd.Parameters.Add("@isActive", SqlDbType.Bit).Value = dt.isActive;
cmd.Parameters.Add("@limitId", SqlDbType.Int).Value = dt.limitId;
cmd.Parameters.Add("@IsUnLimit", SqlDbType.Bit).Value = dt.isUnLimit;
ConnectionData.OpenMyConnection();
cmd.ExecuteNonQuery();
cmd.Dispose();
ConnectionData.CloseMyConnection();
}
public void tblPackageLimit_Update(PackageLimitDTO dt)
{
sign.tblPackageLimit_Update(dt);
}
public void tblPackageLimit_insert(PackageLimitDTO dt)
{
ConnectionData.OpenMyConnection();
string sql = "INSERT INTO tblPackageLimit (namepackagelimit,under,cost,isActive, IsUnLimit) " +
"VALUES( @namepackagelimit, @under,@cost,@isActive, @IsUnLimit) ";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@namepackagelimit", SqlDbType.NVarChar).Value = dt.namepackagelimit;
cmd.Parameters.Add("@under", SqlDbType.BigInt).Value = dt.under;
cmd.Parameters.Add("@cost", SqlDbType.Float).Value = dt.cost;
cmd.Parameters.Add("@isActive", SqlDbType.Bit).Value = dt.isActive;
cmd.Parameters.Add("@IsUnLimit", SqlDbType.Bit).Value = dt.isUnLimit;
cmd.ExecuteNonQuery();
cmd.Dispose();
ConnectionData.CloseMyConnection();
}
public void tblPackageLimit_insert(PackageLimitDTO dt)
{
sign.tblPackageLimit_insert(dt);
}
