public static string AddOrUpdatePhieuXuat(int ID, string MaHieuPhieuXuat, string NgayXuat, int?MaDonViNhan, int?MaKhoVatTu,
int?MaTinhChatNhapXuat, int?MaKhoVatTuDen, int?TinhTrang, string GhiChu, int KieuVatTu)
{
string returnMessage = "";
DateTime dtNgayXuat = DateTime.Now;
try
{
dtNgayXuat = DateTime.ParseExact(NgayXuat, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
catch (Exception ex)
{
dtNgayXuat = DateTime.Now;
}
try
{
xRPDataContext dts = new xRPDataContext();
var user = (from u in dts.aspnet_Users where u.UserName == HttpContext.Current.User.Identity.Name select u).FirstOrDefault();
var tc = dts.Qlvt_TinhChatNhapXuats.Where(t => t.ID == MaTinhChatNhapXuat).FirstOrDefault();
int? id = ID == 0 ? 0 : ID;
if (ID == 0)
{
returnMessage = dts.Sp_Qlvt_PhieuXuat_Add_Edit_Deli("ADD", (int?)null, dts.fc_SinhMa(tc == null?"":tc.MaTinhChatNhapXuat, "*"), MaDonViNhan, dtNgayXuat, MaKhoVatTu,
MaKhoVatTuDen, MaTinhChatNhapXuat, KieuVatTu, TinhTrang, GhiChu, user.UserId, user.UserId, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
else
{
returnMessage = dts.Sp_Qlvt_PhieuXuat_Add_Edit_Deli("Edit", ID, MaHieuPhieuXuat, MaDonViNhan, dtNgayXuat, MaKhoVatTu,
MaKhoVatTuDen, MaTinhChatNhapXuat, KieuVatTu, TinhTrang, GhiChu, (Guid?)null, user.UserId, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
dts.Dispose();
if (!string.IsNullOrEmpty(returnMessage))
{
return(returnMessage);
}
return(id.HasValue ? id.Value.ToString() : returnMessage);
}
catch (Exception ex)
{
return("ERROR: " + ex.Message);
}
}
