public async Task <int> DeactiveProdGroupAsync(MstrProductGroup MstrProductGroup)
{
DynamicParameters para = new DynamicParameters();
para.Add("AutoId", MstrProductGroup.AutoId);
para.Add("IsActive", MstrProductGroup.IsActive);
para.Add("UserId", MstrProductGroup.CreateUserId);
para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = await DbConnection.ExecuteAsync("spMstrProductGroupDeactive", para
, commandType : CommandType.StoredProcedure);
return(para.Get <int>("Result"));
}
public async Task <int> SaveProductGroupAsync(MstrProductGroup MstrProductGroup)
{
DynamicParameters para = new DynamicParameters();
para.Add("AutoId", MstrProductGroup.AutoId);
para.Add("ProdTypeId", MstrProductGroup.ProdTypeId);
para.Add("ProdGroupName", MstrProductGroup.ProdGroupName.Trim());
para.Add("ProdGroupCode", MstrProductGroup.ProdGroupCode.Trim().ToUpper());
//para.Add("SerialNo", MstrProductGroup.SerialNo);
para.Add("UserId", MstrProductGroup.CreateUserId);
para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = await DbConnection.ExecuteAsync("spMstrProductGroupSave", para
, commandType : CommandType.StoredProcedure);
return(para.Get <int>("Result"));
}
