public long UpdateGroupArea(GroupAreaModel model)
{
long res = 0;
// Declare new DataAccess object
ManageDistrictDa dataAccess = new ManageDistrictDa();
using (var transaction = new TransactionScope())
{
MstGroupArea entity = new MstGroupArea();
entity.GROUP_CD = model.GROUP_CD;
entity.GROUP_NAME = model.GROUP_NAME;
entity.FOR_USER = model.FOR_USER;
entity.DEL_FLG = DeleteFlag.NON_DELETE;
entity.INS_DATE = Utility.GetCurrentDateTime();
entity.UPD_DATE = Utility.GetCurrentDateTime();
res = dataAccess.UpdateGroupArea(entity);
if (res <= 0)
{
transaction.Dispose();
}
transaction.Complete();
}
return(res);
}
public long UpdateGroupArea(MstGroupArea entity)
{
long result = 0;
//Check create new customer
StringBuilder sqlinsert = new StringBuilder();
sqlinsert.Append(@"
UPDATE [dbo].[MstGroupArea]
SET [GROUP_NAME] = @GROUP_NAME
,[UPD_DATE] = @UPD_DATE
WHERE [GROUP_CD] = @GROUP_CD ");
result = base.DbUpdate(sqlinsert.ToString(), entity, new { GROUP_CD = entity.GROUP_CD });
return(result);
}
public long InsertGroupArea(MstGroupArea entity)
{
//Check create new customer
StringBuilder sql = new StringBuilder();
sql.Append(@"
INSERT INTO [MstGroupArea]
([GROUP_NAME]
,[FOR_USER]
,[DEL_FLG]
,[INS_DATE]
,[UPD_DATE])
VALUES
(@GROUP_NAME,
@FOR_USER,
@DEL_FLG,
@INS_DATE,
@UPD_DATE)");
var groupCd = base.DbAddGetIdentity(sql.ToString(), entity);
return(groupCd);
}
