public static object Save(CRM_Adv_Duyet item, string username) { using (IDbConnection dbConn = ERPAPD.Helpers.OrmliteConnection.openConn()) { if (item != null) { try { //foreach (var item in items) //{ var checkExits = dbConn.SingleOrDefault <CRM_Adv_Duyet>("fk_adv= {0} AND c_dot_order = {1}", item.fk_adv, item.c_dot_order); if (checkExits == null) { var row = new CRM_Adv_Duyet(); row.fk_adv = (item.fk_adv != 0) ? item.fk_adv : 0; row.fk_staff = (item.fk_staff != 0) ? item.fk_staff : 0; row.c_type = (item.c_type != -100) ? item.c_type : -100; row.c_content = !string.IsNullOrEmpty(item.c_content) ? item.c_content : ""; row.c_ngay_yc_duyet = !string.IsNullOrEmpty(item.c_ngay_yc_duyet.ToString()) ? DateTime.Parse(item.c_ngay_yc_duyet.ToString()) : DateTime.Parse("1900-01-01"); row.c_ngay_duyet = !string.IsNullOrEmpty(item.c_ngay_duyet.ToString()) ? DateTime.Parse(item.c_ngay_duyet.ToString()) : DateTime.Parse("1900-01-01"); row.c_dot_order = !string.IsNullOrEmpty(item.c_dot_order.ToString()) ? item.c_dot_order :0; row.c_input_date = !string.IsNullOrEmpty(item.c_input_date.ToString()) ? DateTime.Parse(item.c_input_date.ToString()) : DateTime.Parse("1900-01-01"); row.RowCreatedUser = username; row.RowUpdatedUser = ""; row.RowCreatedAt = DateTime.Now; row.RowUpdatedAt = DateTime.Parse("1900-01-01"); dbConn.Insert(row); } else { checkExits.fk_adv = (item.fk_adv != 0) ? item.fk_adv : 0; checkExits.fk_staff = (item.fk_staff != 0) ? item.fk_staff : 0; checkExits.c_type = (item.c_type != -100) ? item.c_type : -100; checkExits.c_content = !string.IsNullOrEmpty(item.c_content) ? item.c_content : ""; checkExits.c_ngay_yc_duyet = !string.IsNullOrEmpty(item.c_ngay_yc_duyet.ToString()) ? DateTime.Parse(item.c_ngay_yc_duyet.ToString()) : DateTime.Parse("1900-01-01"); checkExits.c_ngay_duyet = !string.IsNullOrEmpty(item.c_ngay_duyet.ToString()) ? DateTime.Parse(item.c_ngay_duyet.ToString()) : DateTime.Parse("1900-01-01"); checkExits.c_dot_order = !string.IsNullOrEmpty(item.c_dot_order.ToString()) ? item.c_dot_order : 0; checkExits.c_input_date = !string.IsNullOrEmpty(item.c_input_date.ToString()) ? DateTime.Parse(item.c_input_date.ToString()) : DateTime.Parse("1900-01-01"); checkExits.RowUpdatedUser = username; checkExits.RowUpdatedAt = DateTime.Now; dbConn.Update(checkExits); } //} long id = dbConn.GetLastInsertId(); return(new { success = true, message = "Save success!", pk_services = id }); } catch (Exception e) { return(new { success = false, message = e.Message }); } } else { return(new { success = false, message = "Data is null!" }); } } }
public static object Save(IEnumerable <CRM_Adv_Services> items, int c_dot_order, string username) { using (IDbConnection dbConn = ERPAPD.Helpers.OrmliteConnection.openConn()) { if (items != null) { try { if (c_dot_order == 0) { var maxOrder = dbConn.QueryScalar <int>("SELECT MAX(c_dot_order) FROM CRM_Adv_Services WHERE fk_adv = '" + items.FirstOrDefault().fk_adv + "'") + 1; c_dot_order = maxOrder; } long fk_adv = 0; foreach (var item in items) { var checkExits = dbConn.SingleOrDefault <CRM_Adv_Services>("pk_services= {0}", item.pk_services); if (checkExits == null) { var row = new CRM_Adv_Services(); fk_adv = item.fk_adv; row.fk_adv = (item.fk_adv != 0) ? item.fk_adv : 0; row.c_type = (item.c_type != 0) ? item.c_type : 0; row.c_website = !string.IsNullOrEmpty(item.c_website) ? item.c_website : ""; row.c_category = !string.IsNullOrEmpty(item.c_category) ? item.c_category : ""; row.c_location = !string.IsNullOrEmpty(item.c_location) ? item.c_location : ""; row.c_nature = !string.IsNullOrEmpty(item.c_nature) ? item.c_nature : ""; row.c_ngay_len = !string.IsNullOrEmpty(item.c_ngay_lenString) ? DateTime.Parse(item.c_ngay_lenString) : DateTime.Parse("1900-01-01"); row.c_ngay_xuong = !string.IsNullOrEmpty(item.c_ngay_xuongString) ? DateTime.Parse(item.c_ngay_xuongString) : DateTime.Parse("1900-01-01"); row.c_so_luong = !string.IsNullOrEmpty(item.c_so_luong) ? item.c_so_luong : "0"; row.c_size = !string.IsNullOrEmpty(item.c_size) ? item.c_size : ""; row.c_format = !string.IsNullOrEmpty(item.c_format) ? item.c_format : ""; row.c_don_gia = (item.c_don_gia != 0) ? item.c_don_gia : 0; row.c_km = (item.c_km != 0) ? item.c_km : 0; row.c_note = !string.IsNullOrEmpty(item.c_note) ? item.c_note : ""; row.c_gio = (item.c_gio != 0) ? item.c_gio : 0; row.c_chiet_khau1 = (item.c_chiet_khau1 != 0) ? item.c_chiet_khau1 : 0; row.c_chiet_khau2 = (item.c_chiet_khau2 != 0) ? item.c_chiet_khau2 : 0; row.c_chiet_khau3 = (item.c_chiet_khau3 != 0) ? item.c_chiet_khau3 : 0; row.c_vung_mien = (item.c_vung_mien != 0) ? item.c_vung_mien : 0; row.c_ngay_tra_tien = !string.IsNullOrEmpty(item.c_ngay_tra_tienString) ? DateTime.Parse(item.c_ngay_tra_tienString) : DateTime.Parse("1900-01-01"); row.c_tien_tra = (item.c_tien_tra != 0) ? item.c_tien_tra : 0; row.c_luy_ke_da_dang = (item.c_luy_ke_da_dang != 0) ? item.c_luy_ke_da_dang : 0; row.c_dot_order = c_dot_order; row.c_status = (item.c_status != 0) ? item.c_status : 0; row.c_ngay_duyet = !string.IsNullOrEmpty(item.c_ngay_duyetString) ? DateTime.Parse(item.c_ngay_duyetString) : DateTime.Parse("1900-01-01"); row.c_label = !string.IsNullOrEmpty(item.c_label) ? item.c_label : ""; row.c_input_date = DateTime.Now; row.c_edit_date = DateTime.Parse("1900-01-01"); row.fk_staff_edit = (item.fk_staff_edit != 0) ? item.fk_staff_edit : 0; row.c_book_code = !string.IsNullOrEmpty(item.c_book_code) ? item.c_book_code : ""; row.c_ngay_up_ocm = DateTime.Parse("1900-01-01"); row.fk_staff_up_ocm = -1; row.c_kenh_qc = !string.IsNullOrEmpty(item.c_kenh_qc) ? item.c_kenh_qc : ""; row.c_chuyen_muc_kenhqc = !string.IsNullOrEmpty(item.c_chuyen_muc_kenhqc) ? item.c_chuyen_muc_kenhqc : ""; row.c_vi_tri_kenhqc = !string.IsNullOrEmpty(item.c_vi_tri_kenhqc) ? item.c_vi_tri_kenhqc : ""; row.IsNew = 1; row.c_don_gia_sau_ck = (item.c_don_gia_sau_ck != 0) ? item.c_don_gia_sau_ck : 0; row.RowCreatedUser = username; row.RowUpdatedUser = ""; row.RowCreatedAt = DateTime.Now; row.RowUpdatedAt = DateTime.Parse("1900-01-01"); dbConn.Insert(row); } else { fk_adv = item.fk_adv; checkExits.fk_adv = (item.fk_adv != 0) ? item.fk_adv : 0; checkExits.c_type = (item.c_type != 0) ? item.c_type : 0; checkExits.c_website = !string.IsNullOrEmpty(item.c_website) ? item.c_website : ""; checkExits.c_category = !string.IsNullOrEmpty(item.c_category) ? item.c_category : ""; checkExits.c_location = !string.IsNullOrEmpty(item.c_location) ? item.c_location : ""; checkExits.c_nature = !string.IsNullOrEmpty(item.c_nature) ? item.c_nature : ""; checkExits.c_ngay_len = !string.IsNullOrEmpty(item.c_ngay_lenString) ? DateTime.Parse(item.c_ngay_lenString) : checkExits.c_ngay_len; checkExits.c_ngay_xuong = !string.IsNullOrEmpty(item.c_ngay_xuongString) ? DateTime.Parse(item.c_ngay_xuongString) : checkExits.c_ngay_xuong; checkExits.c_so_luong = !string.IsNullOrEmpty(item.c_so_luong) ? item.c_so_luong : "0"; checkExits.c_size = !string.IsNullOrEmpty(item.c_size) ? item.c_size : ""; checkExits.c_format = !string.IsNullOrEmpty(item.c_format) ? item.c_format : ""; checkExits.c_don_gia = (item.c_don_gia != 0) ? item.c_don_gia : 0; checkExits.c_km = (item.c_km != 0) ? item.c_km : 0; checkExits.c_note = !string.IsNullOrEmpty(item.c_note) ? item.c_note : ""; checkExits.c_gio = (item.c_gio != 0) ? item.c_gio : 0; checkExits.c_chiet_khau1 = (item.c_chiet_khau1 != 0) ? item.c_chiet_khau1 : 0; checkExits.c_chiet_khau2 = (item.c_chiet_khau2 != 0) ? item.c_chiet_khau2 : 0; checkExits.c_chiet_khau3 = (item.c_chiet_khau3 != 0) ? item.c_chiet_khau3 : 0; checkExits.c_vung_mien = (item.c_vung_mien != 0) ? item.c_vung_mien : 0; checkExits.c_ngay_tra_tien = !string.IsNullOrEmpty(item.c_ngay_tra_tienString) ? DateTime.Parse(item.c_ngay_tra_tienString) : checkExits.c_ngay_tra_tien; checkExits.c_tien_tra = (item.c_tien_tra != 0) ? item.c_tien_tra : 0; checkExits.c_luy_ke_da_dang = (item.c_luy_ke_da_dang != 0) ? item.c_luy_ke_da_dang : 0; checkExits.c_order = (item.c_order != 0) ? item.c_order : 0; checkExits.c_status = (item.c_status != 0) ? item.c_status : 0; checkExits.c_ngay_duyet = !string.IsNullOrEmpty(item.c_ngay_duyetString) ? DateTime.Parse(item.c_ngay_duyetString) : checkExits.c_ngay_duyet; checkExits.c_tien_tra = (item.c_tien_tra != 0) ? item.c_tien_tra : 0; checkExits.c_label = !string.IsNullOrEmpty(item.c_label) ? item.c_label : ""; checkExits.c_edit_date = DateTime.Now; checkExits.fk_staff_edit = (item.fk_staff_edit != 0) ? item.fk_staff_edit : 0; checkExits.c_book_code = !string.IsNullOrEmpty(item.c_book_code) ? item.c_book_code : ""; //checkExits.c_dot_order = (item.c_dot_order != 0) ? item.c_dot_order : 0; //checkExits.c_ngay_up_ocm = !string.IsNullOrEmpty(item.c_ngay_up_ocmString) ? DateTime.Parse(item.c_ngay_up_ocmString) : checkExits.c_ngay_up_ocm; //checkExits.fk_staff_up_ocm = (item.fk_staff_up_ocm != 0) ? item.fk_staff_up_ocm : 0; checkExits.c_kenh_qc = !string.IsNullOrEmpty(item.c_kenh_qc) ? item.c_kenh_qc : ""; checkExits.c_chuyen_muc_kenhqc = !string.IsNullOrEmpty(item.c_chuyen_muc_kenhqc) ? item.c_chuyen_muc_kenhqc : ""; checkExits.c_vi_tri_kenhqc = !string.IsNullOrEmpty(item.c_vi_tri_kenhqc) ? item.c_vi_tri_kenhqc : checkExits.c_vi_tri_kenhqc; checkExits.c_don_gia_sau_ck = (item.c_don_gia_sau_ck != 0) ? item.c_don_gia_sau_ck : checkExits.c_don_gia_sau_ck; checkExits.RowUpdatedUser = username; checkExits.RowUpdatedAt = DateTime.Now; dbConn.Update(checkExits); } } long id = dbConn.GetLastInsertId(); var duyet = dbConn.Where <CRM_Adv_Duyet>(p => p.fk_adv == fk_adv && p.c_dot_order == c_dot_order).FirstOrDefault(); if (duyet == null) { CRM_Adv_Duyet n = new CRM_Adv_Duyet(); n.fk_adv = fk_adv; n.fk_staff = -1; n.c_type = -100; n.c_dot_order = c_dot_order; n.c_ngay_yc_duyet = DateTime.Parse("1900-01-01"); CRM_Adv_Duyet.Save(n, username); } return(new { success = true, message = "Save success!", pk_services = id, c_dot_order = c_dot_order }); } catch (Exception e) { return(new { success = false, message = e.Message }); } } else { return(new { success = false, message = "Data is null!" }); } } }