public string tab4(PatronEntity patronEntity)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<z304>");
stringBuilder.Append("<record-action>A</record-action>");
stringBuilder.Append("<email-address>" + patronEntity.email + "</email-address>");
stringBuilder.Append("<z304-id>" + patronEntity.pationID + "</z304-id>");
stringBuilder.Append("<z304-sequence>01</z304-sequence>");
stringBuilder.Append("<z304-address-0>" + patronEntity.gioiTinh + " " + patronEntity.HoTen + "</z304-address-0>");
stringBuilder.Append("<z304-address-1>" + patronEntity.DiaChi + "</z304-address-1>");
stringBuilder.Append("<z304-zip></z304-zip>");
stringBuilder.Append("<z304-email-address>" + patronEntity.email + "</z304-email-address>");
stringBuilder.Append("<z304-telephone>" + patronEntity.phone + "</z304-telephone>");
stringBuilder.Append("<z304-date-from>" + patronEntity.Day + "</z304-date-from>");
stringBuilder.Append("<z304-date-to>" + patronEntity.NgayHetHan + "</z304-date-to>");
stringBuilder.Append("<z304-address-type>01</z304-address-type>");
stringBuilder.Append("<z304-telephone-2></z304-telephone-2>");
stringBuilder.Append("<z304-telephone-3></z304-telephone-3>");
stringBuilder.Append("<z304-telephone-4></z304-telephone-4>");
stringBuilder.Append("<z304-sms-number></z304-sms-number>");
stringBuilder.Append("<z304-update-date>" + patronEntity.Day + "</z304-update-date>");
stringBuilder.Append("<z304-cat-name>MASTER</z304-cat-name>");
stringBuilder.Append("</z304>");
return(stringBuilder.ToString());
}
public List <PatronEntity> AddDataPatron(string PatronIdFirst, DataTable dataExcel)
{
int num = int.Parse(PatronIdFirst);
List <PatronEntity> listPatronOrigin = new List <PatronEntity>();
foreach (DataRow row in dataExcel.Rows)
{
string maSinhVien = row.Field <string>(1);
if (!String.IsNullOrEmpty(maSinhVien))
{
PatronEntity patron = new PatronEntity();
patron.pationID = $"{num:000000000000}";
patron.MaSV_O = maSinhVien;
patron.HoTen = row.Field <string>(2);
patron.Day = DateTime.Now.ToString("yyyyMMdd");
patron.ngaySinh = new ToolP().formatDate(row.Field <string>(3));
patron.gioiTinh = new ToolP().convertGender(row.Field <string>(4));
patron.phone = row.Field <string>(5);
patron.email = row.Field <string>(6);
patron.lopHoc = row.Field <string>(7);
patron.Khoa = row.Field <string>(8); //Khoa\\\
patron.khoaHoc = row.Field <string>(9); //Khóa học
patron.DiaChi = row.Field <string>(10);
patron.NgayHetHan = new ToolP().formatDate(row.Field <string>(11));
patron.password = new ToolP().formatDatePassword(row.Field <string>(3));
DataDBLocal.ListPatronOrigin.Add(patron);
num++;
}
}
return(listPatronOrigin);
}
public string tab8(PatronEntity patronEntity)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<z308>");
stringBuilder.Append("<record-action>A</record-action>");
stringBuilder.Append("<z308-key-type>00</z308-key-type>");
stringBuilder.Append("<z308-key-data>" + patronEntity.pationID + "</z308-key-data>");
stringBuilder.Append("<z308-user-library></z308-user-library>");
stringBuilder.Append("<z308-verification>" + patronEntity.password + "</z308-verification>");
stringBuilder.Append("<z308-verification-type>00</z308-verification-type>");
stringBuilder.Append("<z308-id>" + patronEntity.pationID + "</z308-id>");
stringBuilder.Append("<z308-status>AC</z308-status>");
stringBuilder.Append("<z308-encryption>H</z308-encryption>");
stringBuilder.Append("</z308>");
stringBuilder.Append("<z308>");
stringBuilder.Append("<record-action>A</record-action>");
stringBuilder.Append("<z308-key-type>01</z308-key-type>");
stringBuilder.Append("<z308-key-data>" + patronEntity.MaSV_O + "</z308-key-data>");
stringBuilder.Append("<z308-user-library></z308-user-library>");
stringBuilder.Append("<z308-verification>" + patronEntity.password + "</z308-verification>");
stringBuilder.Append("<z308-verification-type>00</z308-verification-type>");
stringBuilder.Append("<z308-id>" + patronEntity.pationID + "</z308-id>");
stringBuilder.Append("<z308-status>AC</z308-status>");
stringBuilder.Append("<z308-encryption>H</z308-encryption>");
stringBuilder.Append("</z308>");
return(stringBuilder.ToString());
}
public string tab3(PatronEntity patronEntity)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<z303>");
stringBuilder.Append("<match-id-type>00</match-id-type>");
stringBuilder.Append("<match-id>" + patronEntity.pationID + "</match-id>");
stringBuilder.Append("<record-action>A</record-action>");
stringBuilder.Append("<z303-id>" + patronEntity.pationID + "</z303-id>");
stringBuilder.Append("<z303-proxy-for-id></z303-proxy-for-id>");
stringBuilder.Append("<z303-primary-id></z303-primary-id>");
stringBuilder.Append("<z303-name-key>" + addNameKey(patronEntity.HoTen) + patronEntity.pationID + "</z303-name-key>");
stringBuilder.Append("<z303-user-type></z303-user-type>");
stringBuilder.Append("<z303-user-library></z303-user-library>");
stringBuilder.Append("<z303-open-date>" + patronEntity.Day + "</z303-open-date>");
stringBuilder.Append("<z303-update-date>" + patronEntity.Day + "</z303-update-date>");
stringBuilder.Append("<z303-con-lng>VIE</z303-con-lng>");
stringBuilder.Append("<z303-alpha>L</z303-alpha>");
stringBuilder.Append("<z303-name>" + patronEntity.HoTen + "</z303-name>");
stringBuilder.Append("<z303-title>" + patronEntity.gioiTinh + "</z303-title>");
stringBuilder.Append("<z303-delinq-1>00</z303-delinq-1>");
stringBuilder.Append("<z303-delinq-n-1></z303-delinq-n-1>");
stringBuilder.Append("<z303-delinq-1-update-date>" + patronEntity.Day + "</z303-delinq-1-update-date>");
stringBuilder.Append("<z303-delinq-1-cat-name>MASTER</z303-delinq-1-cat-name>");
stringBuilder.Append("<z303-delinq-2>00</z303-delinq-2>");
stringBuilder.Append("<z303-delinq-n-2></z303-delinq-n-2>");
stringBuilder.Append("<z303-delinq-2-update-date>20122203</z303-delinq-2-update-date>");
stringBuilder.Append("<z303-delinq-2-cat-name>MASTER</z303-delinq-2-cat-name>");
stringBuilder.Append("<z303-delinq-3>00</z303-delinq-3>");
stringBuilder.Append("<z303-delinq-n-3></z303-delinq-n-3>");
stringBuilder.Append("<z303-delinq-3-update-date>20122203</z303-delinq-3-update-date>");
stringBuilder.Append("<z303-delinq-3-cat-name>MASTER</z303-delinq-3-cat-name>");
stringBuilder.Append("<z303-budget></z303-budget>");
stringBuilder.Append("<z303-profile-id>VNUA-LDC</z303-profile-id>");
stringBuilder.Append("<z303-ill-library></z303-ill-library>");
stringBuilder.Append("<z303-home-library></z303-home-library>");
stringBuilder.Append("<z303-field-1></z303-field-1>");
stringBuilder.Append("<z303-field-2></z303-field-2>");
stringBuilder.Append("<z303-field-3></z303-field-3>");
stringBuilder.Append("<z303-note-1></z303-note-1>");
stringBuilder.Append("<z303-note-2></z303-note-2>");
stringBuilder.Append("<z303-salutation></z303-salutation>");
stringBuilder.Append("<z303-ill-total-limit>0000</z303-ill-total-limit>");
stringBuilder.Append("<z303-ill-active-limit>0000</z303-ill-active-limit>");
stringBuilder.Append("<z303-dispatch-library></z303-dispatch-library>");
stringBuilder.Append("<z303-birth-date>" + patronEntity.ngaySinh + "</z303-birth-date>");
stringBuilder.Append("<z303-export-consent>N</z303-export-consent>");
stringBuilder.Append("<z303-proxy-id-type>00</z303-proxy-id-type>");
stringBuilder.Append("<z303-send-all-letters>Y</z303-send-all-letters>");
stringBuilder.Append("<z303-plain-html></z303-plain-html>");
stringBuilder.Append("<z303-want-sms>N</z303-want-sms>");
stringBuilder.Append("<z303-plif-modification></z303-plif-modification>");
stringBuilder.Append("<z303-title-req-limit>0000</z303-title-req-limit>");
stringBuilder.Append("<z303-gender>" + getGender(patronEntity.gioiTinh) + "</z303-gender>");
stringBuilder.Append("<z303-birthplace></z303-birthplace>");
stringBuilder.Append("</z303>");
return(stringBuilder.ToString());
}
//Lọc ra các mã không tồn tại và tồn tại
public void CompreRemovePatronListNotExist()
{
List <string> ListExcelBarcode = DataDBLocal.ListExcelBarcode.CloneObject();
DataDBLocal.ListExcelBarcodeNotExist = DataDBLocal.ListExcelBarcode.CloneObject();
//List<Z308> ListExcelAlreadyExists = new List<Z308>();
DataDBLocal.ListAlreadyExists = new List <PatronEntity>();
List <Z308> listZ308 = DataDBLocal.listZ308.CloneObject();
if (ListExcelBarcode != null && ListExcelBarcode.Count > 0)
{
//Lọc các patron tồn tại
// => lấy ra các danh tồn tại
foreach (Z308 item in listZ308)
{
string Z308_REC_KEY = item.Z308_REC_KEY.Trim();
//loại bỏ 2 ký tự đầu của Z308_REC_KEY
Z308_REC_KEY = Z308_REC_KEY.Substring(2);
foreach (string maSV in ListExcelBarcode)
{
//so sánh Z308_REC_KEY(barcode) với mã sinh viên
//nếu = true, thì thêm vào danh sách ListAlreadyExists
if (Z308_REC_KEY.Equals(maSV))
{
//item.Z308_REC_KEY = maSV;
//ListExcelAlreadyExists.Add(item);
PatronEntity p = new PatronEntity();
p.MaSV_O = maSV;
p.HoTen = item.Z308_ENCRYPTION;
DataDBLocal.ListAlreadyExists.Add(p);
}
}
}
//Xóa các patron đã tồn tại ra khỏi danh sách
//Để được danh sách không tồn tại
foreach (PatronEntity item in DataDBLocal.ListAlreadyExists)
{
//tìm kiếm vị trí của từng patron id đã tồn tại
int index = ListExcelBarcode.FindIndex((string maSV) => maSV.Equals(item.MaSV_O));
//xóa patron ra khỏi danh sách
DataDBLocal.ListExcelBarcodeNotExist.RemoveAt(index);
}
}
}
public string tab5(PatronEntity patronEntity, string block, string borStatus, string subLibrary, string holdOnShelf, string bookingPermission, string bookingIgnoreHour, string rushCatRequest)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("<z305>");
stringBuilder.Append("<record-action>A</record-action>");
stringBuilder.Append("<z305-id>" + patronEntity.pationID + "</z305-id>");
stringBuilder.Append("<z305-sub-library>" + subLibrary + "</z305-sub-library>");
stringBuilder.Append("<z305-open-date>" + patronEntity.Day + "</z305-open-date>");
stringBuilder.Append("<z305-update-date>" + patronEntity.Day + "</z305-update-date>");
//stringBuilder.Append("<z305-bor-type>" + bor_type(patronEntity.makh) + "</z305-bor-type>");
stringBuilder.Append("<z305-bor-status>" + borStatus + "</z305-bor-status>");
stringBuilder.Append("<z305-registration-date>" + patronEntity.Day + "</z305-registration-date>");
stringBuilder.Append("<z305-expiry-date>" + patronEntity.NgayHetHan + "</z305-expiry-date>");
stringBuilder.Append("<z305-note></z305-note>");
stringBuilder.Append("<z305-loan-permission>N</z305-loan-permission>");
stringBuilder.Append("<z305-photo-permission>N</z305-photo-permission>");
stringBuilder.Append("<z305-over-permission>N</z305-over-permission>");
stringBuilder.Append("<z305-multi-hold>N</z305-multi-hold>");
stringBuilder.Append("<z305-loan-check>N</z305-loan-check>");
stringBuilder.Append("<z305-hold-permission>N</z305-hold-permission>");
stringBuilder.Append("<z305-renew-permission>N</z305-renew-permission>");
stringBuilder.Append("<z305-rr-permission>N</z305-rr-permission>");
stringBuilder.Append("<z305-ignore-late-return>N</z305-ignore-late-return>");
stringBuilder.Append("<z305-last-activity-date>00000000</z305-last-activity-date>");
stringBuilder.Append("<z305-photo-charge>F</z305-photo-charge>");
stringBuilder.Append("<z305-no-loan>0000</z305-no-loan>");
stringBuilder.Append("<z305-no-hold>0000</z305-no-hold>");
stringBuilder.Append("<z305-no-photo>0000</z305-no-photo>");
stringBuilder.Append("<z305-no-cash>0000</z305-no-cash>");
stringBuilder.Append("<z305-cash-limit>0.00</z305-cash-limit>");
stringBuilder.Append("<z305-credit-debit></z305-credit-debit>");
stringBuilder.Append("<z305-sum>0.00</z305-sum>");
stringBuilder.Append("<z305-delinq-1>" + block + "</z305-delinq-1>");
stringBuilder.Append("<z305-delinq-n-1></z305-delinq-n-1>");
stringBuilder.Append("<z305-delinq-1-update-date></z305-delinq-1-update-date>");
stringBuilder.Append("<z305-delinq-1-cat-name>MASTER</z305-delinq-1-cat-name>");
stringBuilder.Append("<z305-delinq-2>00</z305-delinq-2>");
stringBuilder.Append("<z305-delinq-n-2></z305-delinq-n-2>");
stringBuilder.Append("<z305-delinq-2-update-date>" + patronEntity.Day + "</z305-delinq-2-update-date>");
stringBuilder.Append("<z305-delinq-2-cat-name>MASTER</z305-delinq-2-cat-name>");
stringBuilder.Append("<z305-delinq-3>00</z305-delinq-3>");
stringBuilder.Append("<z305-delinq-n-3></z305-delinq-n-3>");
stringBuilder.Append("<z305-delinq-3-update-date>" + patronEntity.Day + "</z305-delinq-3-update-date>");
stringBuilder.Append("<z305-delinq-3-cat-name>MASTER</z305-delinq-3-cat-name>");
stringBuilder.Append("<z305-field-1>" + patronEntity.khoaHoc + "</z305-field-1>");
stringBuilder.Append("<z305-field-2>" + patronEntity.lopHoc + "</z305-field-2>");
stringBuilder.Append("<z305-field-3>" + patronEntity.Khoa + "</z305-field-3>");
stringBuilder.Append("<z305-hold-on-shelf>" + holdOnShelf + "</z305-hold-on-shelf>");
stringBuilder.Append("<z305-end-block-date>00000000</z305-end-block-date>");
stringBuilder.Append("<z305-booking-permission>" + bookingPermission + "</z305-booking-permission>");
stringBuilder.Append("<z305-booking-ignore-hours>" + bookingIgnoreHour + "N</z305-booking-ignore-hours>");
stringBuilder.Append("<z305-rush-cat-request>" + rushCatRequest + "</z305-rush-cat-request>");
stringBuilder.Append("</z305>");
//stringBuilder.Append("<z305>");
//stringBuilder.Append("<record-action>A</record-action>");
//stringBuilder.Append("<z305-id>" + patronEntity.pationID + "</z305-id>");
//stringBuilder.Append("<z305-sub-library>LDC50</z305-sub-library>");
//stringBuilder.Append("<z305-open-date>" + patronEntity.Day + "</z305-open-date>");
//stringBuilder.Append("<z305-update-date>" + patronEntity.Day + "</z305-update-date>");
////stringBuilder.Append("<z305-bor-type>" + bor_type(patronEntity.makh) + "</z305-bor-type>");
//stringBuilder.Append("<z305-bor-status>01</z305-bor-status>");
//stringBuilder.Append("<z305-registration-date>" + patronEntity.Day + "</z305-registration-date>");
//stringBuilder.Append("<z305-expiry-date>" + patronEntity.Day4 + "</z305-expiry-date>");
//stringBuilder.Append("<z305-note></z305-note>");
//stringBuilder.Append("<z305-loan-permission>N</z305-loan-permission>");
//stringBuilder.Append("<z305-photo-permission>N</z305-photo-permission>");
//stringBuilder.Append("<z305-over-permission>N</z305-over-permission>");
//stringBuilder.Append("<z305-multi-hold>N</z305-multi-hold>");
//stringBuilder.Append("<z305-loan-check>N</z305-loan-check>");
//stringBuilder.Append("<z305-hold-permission>N</z305-hold-permission>");
//stringBuilder.Append("<z305-renew-permission>N</z305-renew-permission>");
//stringBuilder.Append("<z305-rr-permission>N</z305-rr-permission>");
//stringBuilder.Append("<z305-ignore-late-return>N</z305-ignore-late-return>");
//stringBuilder.Append("<z305-last-activity-date>00000000</z305-last-activity-date>");
//stringBuilder.Append("<z305-photo-charge>F</z305-photo-charge>");
//stringBuilder.Append("<z305-no-loan>0000</z305-no-loan>");
//stringBuilder.Append("<z305-no-hold>0000</z305-no-hold>");
//stringBuilder.Append("<z305-no-photo>0000</z305-no-photo>");
//stringBuilder.Append("<z305-no-cash>0000</z305-no-cash>");
//stringBuilder.Append("<z305-cash-limit>0.00</z305-cash-limit>");
//stringBuilder.Append("<z305-credit-debit></z305-credit-debit>");
//stringBuilder.Append("<z305-sum>0.00</z305-sum>");
//stringBuilder.Append("<z305-delinq-1>00</z305-delinq-1>");
//stringBuilder.Append("<z305-delinq-n-1></z305-delinq-n-1>");
//stringBuilder.Append("<z305-delinq-1-update-date></z305-delinq-1-update-date>");
//stringBuilder.Append("<z305-delinq-1-cat-name>MASTER</z305-delinq-1-cat-name>");
//stringBuilder.Append("<z305-delinq-2>00</z305-delinq-2>");
//stringBuilder.Append("<z305-delinq-n-2></z305-delinq-n-2>");
//stringBuilder.Append("<z305-delinq-2-update-date>" + patronEntity.Day + "</z305-delinq-2-update-date>");
//stringBuilder.Append("<z305-delinq-2-cat-name>MASTER</z305-delinq-2-cat-name>");
//stringBuilder.Append("<z305-delinq-3>00</z305-delinq-3>");
//stringBuilder.Append("<z305-delinq-n-3></z305-delinq-n-3>");
//stringBuilder.Append("<z305-delinq-3-update-date>" + patronEntity.Day + "</z305-delinq-3-update-date>");
//stringBuilder.Append("<z305-delinq-3-cat-name>MASTER</z305-delinq-3-cat-name>");
//stringBuilder.Append("<z305-field-1>" + patronEntity.khoaHoc + "</z305-field-1>");
//stringBuilder.Append("<z305-field-2>" + patronEntity.lopHoc + "</z305-field-2>");
//stringBuilder.Append("<z305-field-3></z305-field-3>");
//stringBuilder.Append("<z305-hold-on-shelf>N</z305-hold-on-shelf>");
//stringBuilder.Append("<z305-end-block-date>00000000</z305-end-block-date>");
//stringBuilder.Append("<z305-booking-permission>Y</z305-booking-permission>");
//stringBuilder.Append("<z305-booking-ignore-hours>N</z305-booking-ignore-hours>");
//stringBuilder.Append("<z305-rush-cat-request>Y</z305-rush-cat-request>");
//stringBuilder.Append("</z305>");
//stringBuilder.Append("<z305>");
//stringBuilder.Append("<record-action>A</record-action>");
//stringBuilder.Append("<z305-id>" + patronEntity.pationID + "</z305-id>");
//stringBuilder.Append("<z305-sub-library>ALEPH</z305-sub-library>");
//stringBuilder.Append("<z305-open-date>" + patronEntity.Day + "</z305-open-date>");
//stringBuilder.Append("<z305-update-date>" + patronEntity.Day + "</z305-update-date>");
////stringBuilder.Append("<z305-bor-type>" + bor_type(patronEntity.makh) + "</z305-bor-type>");
//stringBuilder.Append("<z305-bor-status>01</z305-bor-status>");
//stringBuilder.Append("<z305-registration-date>" + patronEntity.Day + "</z305-registration-date>");
//stringBuilder.Append("<z305-expiry-date>" + patronEntity.Day4 + "</z305-expiry-date>");
//stringBuilder.Append("<z305-note></z305-note>");
//stringBuilder.Append("<z305-loan-permission>N</z305-loan-permission>");
//stringBuilder.Append("<z305-photo-permission>N</z305-photo-permission>");
//stringBuilder.Append("<z305-over-permission>N</z305-over-permission>");
//stringBuilder.Append("<z305-multi-hold>N</z305-multi-hold>");
//stringBuilder.Append("<z305-loan-check>N</z305-loan-check>");
//stringBuilder.Append("<z305-hold-permission>N</z305-hold-permission>");
//stringBuilder.Append("<z305-renew-permission>N</z305-renew-permission>");
//stringBuilder.Append("<z305-rr-permission>N</z305-rr-permission>");
//stringBuilder.Append("<z305-ignore-late-return>N</z305-ignore-late-return>");
//stringBuilder.Append("<z305-last-activity-date>00000000</z305-last-activity-date>");
//stringBuilder.Append("<z305-photo-charge>F</z305-photo-charge>");
//stringBuilder.Append("<z305-no-loan>0000</z305-no-loan>");
//stringBuilder.Append("<z305-no-hold>0000</z305-no-hold>");
//stringBuilder.Append("<z305-no-photo>0000</z305-no-photo>");
//stringBuilder.Append("<z305-no-cash>0000</z305-no-cash>");
//stringBuilder.Append("<z305-cash-limit>0.00</z305-cash-limit>");
//stringBuilder.Append("<z305-credit-debit></z305-credit-debit>");
//stringBuilder.Append("<z305-sum>0.00</z305-sum>");
//stringBuilder.Append("<z305-delinq-1>00</z305-delinq-1>");
//stringBuilder.Append("<z305-delinq-n-1></z305-delinq-n-1>");
//stringBuilder.Append("<z305-delinq-1-update-date></z305-delinq-1-update-date>");
//stringBuilder.Append("<z305-delinq-1-cat-name>MASTER</z305-delinq-1-cat-name>");
//stringBuilder.Append("<z305-delinq-2>00</z305-delinq-2>");
//stringBuilder.Append("<z305-delinq-n-2></z305-delinq-n-2>");
//stringBuilder.Append("<z305-delinq-2-update-date>" + patronEntity.Day + "</z305-delinq-2-update-date>");
//stringBuilder.Append("<z305-delinq-2-cat-name>MASTER</z305-delinq-2-cat-name>");
//stringBuilder.Append("<z305-delinq-3>00</z305-delinq-3>");
//stringBuilder.Append("<z305-delinq-n-3></z305-delinq-n-3>");
//stringBuilder.Append("<z305-delinq-3-update-date>" + patronEntity.Day + "</z305-delinq-3-update-date>");
//stringBuilder.Append("<z305-delinq-3-cat-name>MASTER</z305-delinq-3-cat-name>");
//stringBuilder.Append("<z305-field-1>" + patronEntity.khoaHoc + "</z305-field-1>");
//stringBuilder.Append("<z305-field-2>" + patronEntity.lopHoc + "</z305-field-2>");
//stringBuilder.Append("<z305-field-3></z305-field-3>");
//stringBuilder.Append("<z305-hold-on-shelf>N</z305-hold-on-shelf>");
//stringBuilder.Append("<z305-end-block-date>00000000</z305-end-block-date>");
//stringBuilder.Append("<z305-booking-permission>Y</z305-booking-permission>");
//stringBuilder.Append("<z305-booking-ignore-hours>N</z305-booking-ignore-hours>");
//stringBuilder.Append("<z305-rush-cat-request>Y</z305-rush-cat-request>");
//stringBuilder.Append("</z305>");
return(stringBuilder.ToString());
}