public static void InsertNhanVienDangTruc(string strCon, string MSNV, byte Catruc, string ThoiGianLuu)
{
string[] parameterNames = new string[]
{
"@MSNV",
"@CaTruc",
"@ThoiGianLuu"
};
string[] parameterValues = new string[]
{
MSNV,
Catruc.ToString(),
ThoiGianLuu
};
try
{
CSDL.InCSDLByProcedure(strCon, "InNhanVienDangTruc", parameterNames, parameterValues, 3);
}
catch (Exception expr_4C)
{
ProjectData.SetProjectError(expr_4C);
Exception ex = expr_4C;
ModuleKhac.SaveError(ex.Message, "InNhanVienDangTruc");
ProjectData.ClearProjectError();
}
}
public static void InsertValiDataBackup(string strCon)
{
string[] parameterNames = new string[]
{
""
};
string[] parameterValues = new string[]
{
""
};
CSDL.InCSDLByProcedure(strCon, "InValiBackup", parameterNames, parameterValues, 0);
}
public static void UpXeQuaTram(string strCon, string TenHinhXe, byte PLXeSau)
{
string[] parameterNames = new string[]
{
"@TenHinhXe",
"@PLXeSau"
};
string[] parameterValues = new string[]
{
TenHinhXe,
Conversions.ToString(PLXeSau)
};
CSDL.InCSDLByProcedure(strCon, "UpxeQuaTram", parameterNames, parameterValues, 2);
}
public static void InsertXeQuaTram(string strCon, XeQuaTram Xe)
{
string[] parameterNames = new string[]
{
"@BienSo",
"@TTXeQua",
"@SoVe",
"@PLXeTruoc",
"@PLVe",
"@PLXeSau",
"@PTTT",
"@Phi",
"@LanXe",
"@NgayQuaTram",
"@GioQuaTram",
"@CaTruc",
"@MSNV",
"@TenHinhXe",
"@BSXeThangQui"
};
string[] parameterValues = new string[]
{
Xe.BienSo,
Conversions.ToString(Xe.TTXeQua),
Xe.SoVe,
Conversions.ToString(Xe.PLXeTruoc),
Conversions.ToString(Xe.PLVe),
Conversions.ToString(Xe.PLXeSau),
Conversions.ToString(Xe.PTTT),
Conversions.ToString(Xe.Phi),
Conversions.ToString(Xe.LanXe),
Xe.NgayQuaTram,
Xe.GioQuaTram,
Conversions.ToString(Xe.CaTruc),
Xe.MSNV,
Xe.TenHinhXe,
Xe.BSXeThangQui
};
try
{
CSDL.InCSDLByProcedure(strCon, "InXeQuaTram", parameterNames, parameterValues, 15);
}
catch (Exception expr_158)
{
ProjectData.SetProjectError(expr_158);
ProjectData.ClearProjectError();
}
}
public static void DeleteXeQuaTram_TienPhong(string strCon, string TenHinhXe)
{
string[] parameterNames = new string[]
{
"@TenHinhXe"
};
string[] parameterValues = new string[]
{
TenHinhXe
};
try
{
CSDL.InCSDLByProcedure(strCon, "DeXeQuaTramTienPhong", parameterNames, parameterValues, 1);
}
catch (Exception expr_2E)
{
ProjectData.SetProjectError(expr_2E);
Exception ex = expr_2E;
ModuleKhac.SaveError(ex.Message, "DeleteXeQuaTramTienPhong");
ProjectData.ClearProjectError();
}
}
public static void DeleteVeSuDung(string strCon)
{
string[] parameterNames = new string[]
{
""
};
string[] parameterValues = new string[]
{
""
};
try
{
CSDL.InCSDLByProcedure(strCon, "DeVeSuDung", parameterNames, parameterValues, 0);
}
catch (Exception expr_32)
{
ProjectData.SetProjectError(expr_32);
Exception ex = expr_32;
ModuleKhac.SaveError(ex.Message, "DeleteVeSuDung");
ProjectData.ClearProjectError();
}
}
public static void InsertVeSuDung(string strCon, string SoVe)
{
string[] parameterNames = new string[]
{
"@SoVe"
};
string[] parameterValues = new string[]
{
SoVe
};
try
{
CSDL.InCSDLByProcedure(strCon, "InVeSuDung", parameterNames, parameterValues, 1);
}
catch (Exception expr_2E)
{
ProjectData.SetProjectError(expr_2E);
Exception ex = expr_2E;
ModuleKhac.SaveError(ex.Message, "InsertVeSuDung");
ProjectData.ClearProjectError();
}
}