public void stationUpdate(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Update_station '"
+ bllcreate.STATIONID + "','"
+ bllcreate.DIVISION + "' ,'"
+ bllcreate.DISTRICT + "' ,'"
+ bllcreate.POLICESTATION + "' ,'"
+ bllcreate.POSTOFFICE + "' ,'"
+ bllcreate.UNION + "' ,'"
+ bllcreate.STATIONBAN + "' ,'"
+ bllcreate.STATIONENG + "' ,'"
+ bllcreate.DEFAULTCOPY + "' ,'"
+ bllcreate.PACKTYPE + "' ,'"
+ bllcreate.SUBROUTENAME + "' ,'"
+ bllcreate.SORTINGORDER + "' ,'"
+ bllcreate.AUDITUSER + "' ,'"
+ bllcreate.CREATEDATE + "' ";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void stationDelete(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Delete_station '" + bllcreate.STATIONID + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void poDelete(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Delete_postOffice '" + bllcreate.POID + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void psDelete(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Delete_policeStation '" + bllcreate.PSID + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void distDelete(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Delete_district '" + bllcreate.DISTRICTID + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void divInsert(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Insert_division '" + bllcreate.DIVISION + "' ,'"
+ bllcreate.AUDITUSER + "' ,'"
+ bllcreate.CREATEDATE + "' ";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void divDelete(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Delete_division '" + bllcreate.DIVISIONID + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
//Use label to print an error >> lbl.text = e.Message;
}
}
public void psInsert(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Insert_policeStation '" + bllcreate.DIVISION + "' ,'"
+ bllcreate.DISTRICT + "' ,'"
+ bllcreate.POLICESTATION + "' ,'"
+ bllcreate.AUDITUSER + "' ,'"
+ bllcreate.CREATEDATE + "' ";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void distUpdate(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Update_district '"
+ bllcreate.DISTRICTID + "','"
+ bllcreate.DIVISION + "' ,'"
+ bllcreate.DISTRICT + "' ,'"
+ bllcreate.AUDITUSER + "' ,'"
+ bllcreate.CREATEDATE + "' ";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void poUpdate(bll_CreateRegion bllcreate)
{
try
{
cmd = "EXEC Update_postOffice '"
+ bllcreate.POID + "','"
+ bllcreate.DIVISION + "' ,'"
+ bllcreate.DISTRICT + "' ,'"
+ bllcreate.POLICESTATION + "' ,'"
+ bllcreate.POSTOFFICE + "' ,'"
+ bllcreate.POCODE + "' ,'"
+ bllcreate.AUDITUSER + "' ,'"
+ bllcreate.CREATEDATE + "' ";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}