public Model2 OneInOneOut(Model1 input)
{
return new Model2
{
Name = input.Name
};
}
public void Multiply(string x, string y)
{
Model1 m = new Model1();
m.X = int.Parse(x);
m.Y = int.Parse(y);
xmlBody.Document = m.Product;
xmlBody.TransformSource = "Page2.xslt";
}
// This view method takes two parameters that are the manipulated
// by the Model component.
public void View(string x, string y)
{
Model1 m = new Model1();
m.X = int.Parse(x);
m.Y = int.Parse(y);
xmlBody.Document = m.Xml;
xmlBody.TransformSource = "Page1.xslt";
}
public void HtmlTag_Input_Value_Null()
{
var model = new Model1() { PropInt = null };
var helper = new HtmlTagHelper(model);
var tagName = "input";
var name = "PropInt";
var tag = helper.HtmlTag(tagName, name);
AssertValid(tag, tagName, name, value: model.PropInt);
}
public void HtmlTag_Input_Value_Date()
{
var model = new Model1() { PropDate = DateTime.UtcNow };
var helper = new HtmlTagHelper(model);
var tagName = "input";
var name = "PropDate";
var tag = helper.HtmlTag(tagName, name);
AssertValid(tag, tagName, name, value: model.PropDate);
}
public void LoadProperty(string propertyName)
{
if (Id == 0) return;
using (var db = new Model1())
{
IEnumerable rootCollection = GetRootCollection(db, this.GetType());
rootCollection.GetType().GetMethod("Attach").Invoke(rootCollection, new object[] { this });
this.GetType().GetProperty(propertyName).SetValue(this, db.Entry(this).GetDatabaseValues().GetValue<object>(propertyName));
}
}
// TODO: REFACTOR
public IEnumerable LoadCollection(string collectionPropertyName)
{
using (var db = new Model1())
{
IEnumerable rootCollection = GetRootCollection(db, this.GetType());
rootCollection.GetType().GetMethod("Attach").Invoke(rootCollection, new object[] { this });
var dbCollectionEntry = db.Entry(this).Collection(collectionPropertyName);
dbCollectionEntry.Load();
IEnumerable childCollection = (IEnumerable)dbCollectionEntry.CurrentValue;
childCollection.GetType().GetField("Parent").SetValue(childCollection, this);
return childCollection;
}
}
public void Holder_type_with_a_model_and_service_locator()
{
var services = MockRepository.GenerateMock<IServiceLocator>();
var theModel = new Model1();
var request = ElementRequest.For<Model1>(theModel, x => x.Child.Name, services);
var resolver = MockRepository.GenerateMock<ITypeResolver>();
services.Stub(x => x.GetInstance<ITypeResolver>()).Return(resolver);
resolver.Stub(x => x.ResolveType(theModel)).Return(GetType());
request.HolderType().ShouldEqual(GetType());
}
public void get_access_rights()
{
var services = MockRepository.GenerateMock<IServiceLocator>();
var rightsService = MockRepository.GenerateMock<IFieldAccessService>();
services.Stub(x => x.GetInstance<IFieldAccessService>()).Return(rightsService);
var theModel = new Model1();
var request = ElementRequest.For<Model1>(theModel, x => x.Child.Name, services);
rightsService.Stub(x => x.RightsFor(request)).Return(AccessRight.ReadOnly);
request.AccessRights().ShouldEqual(AccessRight.ReadOnly);
}
// TODO: REFACTOR
public EFBase LoadReference(string referencePropertyName)
{
EFBase reference = (EFBase)RealType(this.GetType()).GetProperty(referencePropertyName).GetValue(this);
if (reference != null) return reference;
using (var db = new Model1())
{
IEnumerable rootCollection = GetRootCollection(db, this.GetType());
rootCollection.GetType().GetMethod("Attach").Invoke(rootCollection, new object[] { this });
var dbReferenceEntry = db.Entry(this).Reference(referencePropertyName);
dbReferenceEntry.Load();
reference = (EFBase)dbReferenceEntry.CurrentValue;
}
return reference;
}
public void get_tags_for_a_model_type()
{
var theModel = new Model1();
var locator = MockRepository.GenerateMock<IServiceLocator>();
var types = MockRepository.GenerateMock<ITypeResolver>();
locator.Stub(x => x.GetInstance<ITypeResolver>()).Return(types);
types.Stub(x => x.ResolveType(theModel)).Return(typeof (Model2));
var tags = MockRepository.GenerateMock<ITagGenerator<Model2>>();
locator.Stub(x => x.GetInstance(typeof(ITagGenerator<Model2>))).Return(tags);
locator.TagsFor(theModel).ShouldBeTheSameAs(tags);
}
// [TestMethod]
public void AutoMapFilterTest()
{
var sourceModel = new Model1
{
Property1 = 1,
Property2 = "Prop 2",
Property3 = "Prop 3",
Property4 = "Prop 4"
};
var destModel = new Model2
{
Property1 = 1,
Property2 = "Prop 2"
};
}
public void get_one_M1(Model1 input)
{
}
public SanPhamDao()
{
db = new Model1();
}
private static User CreateUser(RegisterModel model, Model1 db)
{
User user;
string login = model.Email.Split('@')[0];
Role role = db.Roles.Where(r => r.RoleName.Contains("client")).FirstOrDefault();
role = IsRole(role, "client"); //проверка, если надо-установ.
user = new User
{
FullName = model.FullName,
BirthDay = model.BirthDay,
Phone = model.Phone,
Email = model.Email,
Login = login,
Password = model.Password
}; //Role - далее, Gender, Graphic - в Edit-активн.
//1-client
if (model.Token == null || model.Token.Equals("")) //Токен выдается административно или не выдается
{
user.Role = role;
db.Users.Add(user);
db.Clients.Add(new Clients {
User = user
});
}
//2-managers
else if (model.Token.Contains("manager")) //может быть и 1234-ABCD-..
{
//int key = int.Parse(new Regex(@"\d").Match(model.Token).Value);
if (!model.Token.Contains("top"))
{
role = db.Roles.Where(r => r.RoleName.Equals("manager")).FirstOrDefault();
role = IsRole(role, "manager");
user.Role = role;
db.Users.Add(user);
user.Token = "manager1";
db.Administrations.Add(new Administration {
User = user, Status = Administration.StatusManager.MANAGER
});
}
else
{
role = db.Roles.Where(r => r.RoleName.Equals("top_manager")).FirstOrDefault();
role = IsRole(role, "top_manager");
user.Role = role;
db.Users.Add(user);
user.Token = "top_manager";
db.Administrations.Add(new Administration {
User = user, Status = Administration.StatusManager.TOP_MANAGER
});
}
}
//3-coaches
else if (model.Token.Contains("coache"))
{
var specialization = db.Specializations.Where(s => s.Title.Contains("individ")).FirstOrDefault(); //сначала все индивидуал
db.Users.Add(user);
int key = int.Parse(new Regex(@"\d").Match(model.Token).Value);
if (key == 1)
{
role = db.Roles.Where(r => r.RoleName.Equals("coache")).FirstOrDefault();
role = IsRole(role, "coache");
user.Role = role;
user.Token = "coache1";
db.Coaches.Add(new Coaches {
User = user, Status = Coaches.StatusCoach.COACHE, SpecializationId = specialization.Id
});
}
else if (key == 2)
{
role = db.Roles.Where(r => r.RoleName.Equals("head_coache")).FirstOrDefault();
role = IsRole(role, "head_coache");
user.Role = role;
user.Token = "coache2";
db.Coaches.Add(new Coaches {
User = user, Status = Coaches.StatusCoach.HEAD_COACHE_HALL, SpecializationId = specialization.Id
});
}
else
{
role = db.Roles.Where(r => r.RoleName.Equals("top_coache")).FirstOrDefault();
role = IsRole(role, "top_coache");
user.Role = role;
user.Token = "coache3";
db.Coaches.Add(new Coaches {
User = user, Status = Coaches.StatusCoach.TOP_COACHE, SpecializationId = specialization.Id
});
}
}
db.SaveChanges();
//юзаем юзера..
user = db.Users.Where(u => u.FullName == model.FullName && u.Password == model.Password).FirstOrDefault();
return(user);
}
public FubuContinuation GoAfter(Model1 input)
{
return null;
}
public void GivenIClickOnTheDesiredCarModel()
{
WaitHelpers.TurnOnWait();
Model1.Click();
}
public void A(Model1 model)
{
}
public void View()
{
Model1 m = new Model1();
xmlBody.Document = m.Xml;
xmlBody.TransformSource = "Page1.xslt";
}
public ProductDetailF()
{
context = new Model1();
}
public static trashtype updateli(int id)
{
Model1 mo = new Model1();
return(mo.trashtype.FirstOrDefault(p => p.typeId == id));
}
public StudentRepository(Model1 dbcontext) : base(dbcontext)
{
}
public DataBaseFactory()
{
datacontext = new Model1();
}
public RepositoryBase(Model1 _ctx)
{
_set = _ctx.Set <TEntity>();
}
public CourseManager()
{
ctx = new Model1();
}
public void SelectUserMaxSum()
{
using (var ctx = new Model1())
{
}
}
public ProductController()
{
db = new Model1();
}
public Repository()
{
this.db = new Model1();
this.table = db.Set <T>();
}
public void post_Green_model(Model1 model)
{
}
//public Repository(DbSet objects)
//{
//}
public Repository(Model1 db)
{
this.db = db;
this.table = db.Set <T>();
}
public void C(Model1 model)
{
}
public void Alert()
{
try
{
if (!isRunning)
{
isRunning = true;
var AlertTimes = int.Parse(System.Configuration.ConfigurationManager.AppSettings["AlertTimes"]);
using (var db = new Model1())
{
SqlParameter[] sqlParms = new SqlParameter[1];
sqlParms[0] = new SqlParameter("@alerttimes", AlertTimes);
alertData = db.Database.SqlQuery <SaleRecord>("exec QuerySaleRecrod @alerttimes", sqlParms).ToList();
var vipInfos = db.t_rm_vip_info.ToList();
var ignoretxt = INIHelper.ReadString("IgnoreVIP", DirectoryManage.GetINIFullPath());
var ignoreList = ignoretxt.Split(',');
var mode = System.Configuration.ConfigurationManager.AppSettings["Mode"] == "debug";
if (mode)
{
MessageBox.Show("vip数量：" + vipInfos.Count.ToString());
}
foreach (var vipinfo in vipInfos)
{
try
{
//if (vipinfo.vip_start_date.HasValue && vipinfo.vip_start_date.Value.Month == DateTime.Now.Month)
//{//当月不反积分
// if (mode)
// {
// MessageBox.Show("当月不反积分");
// }
// continue;
//}
if (db.t_rm_vip_acclist.Where(o => o.oper_des == "活动##送积分" && o.memo == "活动##送积分" && o.card_no == vipinfo.card_no).Count() > 15)
{
if (mode)
{
MessageBox.Show("已经超过送积分次数 则跳过");
}
continue;
}
var accnum = int.Parse(System.Configuration.ConfigurationManager.AppSettings["VipAccnum"]);
var acclist = db.t_rm_vip_acclist.Where(o => o.oper_des == "活动##送积分" && o.memo == "活动##送积分" && o.card_no == vipinfo.card_no).ToList();
if (acclist.Count > 0)
{
var date1 = acclist.OrderByDescending(o => o.ope_date).FirstOrDefault().ope_date.Value.AddDays(30);
if (date1 >= DateTime.Now)
{
if (mode)
{
MessageBox.Show("距离上次送积分还不到30天 则跳过");
}
continue;
}
}
if (ignoreList.Contains(vipinfo.card_no))
{
if (mode)
{
MessageBox.Show("如果会员忽略列表里存在这个会员卡号，择跳过");
}
//如果会员忽略列表里存在这个会员卡号，择跳过
continue;
}
if (mode)
{
MessageBox.Show("vip数量：" + vipInfos.Count.ToString());
}
vipinfo.acc_num = vipinfo.acc_num + accnum;
vipinfo.now_acc_num = vipinfo.now_acc_num + accnum;
db.t_rm_vip_acclist.Add(new t_rm_vip_acclist
{
card_no = vipinfo.card_no,
card_id = vipinfo.card_id,
card_type = vipinfo.card_type,
branch_no = "000",
oper_type = "2",
oper_id = "1001",
ope_date = DateTime.Now,
flow_no = "",
consum_amt = 0,
acc_num = accnum,
oper_des = "活动##送积分",
memo = "活动##送积分"
});
}
catch (Exception ex)
{
MessageBox.Show("错误：" + ex.ToString());
}
}
db.SaveChanges();
if (alertData.Count > 0)
{
MaintainenceAlertForm form = new MaintainenceAlertForm(alertData);
form.ShowDialog();
}
isRunning = false;
}
}
}
catch (Exception ex)
{
MessageBox.Show("错误：" + ex.ToString());
}
}
public void DoTheTask()
{
var type = _num % 2;
const int totle = 2000;
for (var i = 0; i < totle; i++)
{
//var obj = new ModelBase {Id = i.ToString()};
switch (type)
{
case 0:
using (var mc = new MongoDbProvider("Test5", "Mongo27016"))
{
var obj1 = new Model1
{
Id = i + "-" + _num,
Model = "model1-" + i
};
mc.Collection.Save(obj1);
}
break;
case 1:
using (var mc = new MongoDbProvider("Test2", "Mongo27017"))
{
var obj2 = new Model2
{
Id = i + "-" + _num,
Model = "model2-" + i
};
mc.Collection.Save(obj2);
}
break;
}
Console.WriteLine(_num + @" --> " + i);
}
}
public bool getReport()
{
if (window == null)
{
return(false);
}
Model1 db = new Model1();
String sql;
var machine_name = window.comMachineName.Text.ToString();
var process_name = window.comProcessName.Text.ToString();
var machineLeader_name = window.comMachineLeader.Text.ToString();
if (machineLeader_name == "" || process_name == "")
{
MessageBox.Show("工序和机长不能为空");
return(false);
}
var stDate = DateTime.Parse(window.dpStartDate.Text).ToString("yyyy-MM-dd");
var endDate = DateTime.Parse(window.dpEndDate.Text).ToString("yyyy-MM-dd");
//DateTime t1, t2;
//t1 = DateTime.Parse("2018/2/1");
//t2 = DateTime.Parse("2018/12/1");
//if(t2>=t1)
//{
// Console.WriteLine("t2>=t1");
//}
DateTimeFormatInfo dtFormat = new DateTimeFormatInfo();
dtFormat.ShortDatePattern = "yyyy-MM-dd";
DateTime date_start = Convert.ToDateTime(DateTime.Parse(window.dpStartDate.Text).ToString("yyyy-MM-dd"));
DateTime date_end = DateTime.Parse(window.dpEndDate.Text, dtFormat);
string machineNO = "";
var machine_no = dic_machine.Where(x => x.machinename == machine_name).Select(x => x.machineno);
var workunit = user_info.Where(x => x.username == machineLeader_name).Select(x => x.loginname).First();
if (machine_no.Count() > 0)
{
machineNO = machine_no.ToList().ElementAt(0);
}
var processName = (from p in db.DIC_Machines where p.machinename == machine_name join p1 in db.DIC_ProcessType on p.processtype equals p1.ProcessType select p1.ProcessName).ToList <string>();
FastReport.Preview.PreviewControl prew = new FastReport.Preview.PreviewControl();
report.Load(@"report.frx");
report.Parameters[0].Value = machine_name;
//if(processName.Count>0)
report.Parameters[1].Value = process_name;
report.Parameters[2].Value = stDate + "--" + endDate;
report.Parameters[4].Value = machineLeader_name;
var boxCollect = (from p in db.D_BoxCollectResult where p.reportdate >= date_start && p.reportdate <= date_end && p.WorkUnit == workunit orderby p.StartCode select p).ToList <D_BoxCollectResult>();
var WasteCode = (from p in db.D_VerWasteCode where p.ProductionDate >= date_start && p.ProductionDate <= date_end && (p.ProcessType == process_name || p.code == "") orderby p.codeRange, p.code select p).ToList <D_VerWasteCode>();
// var verWasteCode = (from p in db.D_VerWasteCode where p.ProductionDate >= date_start && p.ProductionDate <= date_end && p.MachineNo== machineNO group p by new { p.codeRange, p.Note } into g select new { codeRange = g.Key.codeRange, note=g.Key.Note,_count = g.Count() }).ToList();
DataSet ds = new DataSet();
DataTable table = new DataTable();
table.TableName = "rateView"; // 一定要设置表名称,rateView与实际表关联
DataTable table_un_commite = new DataTable();
table_un_commite.TableName = "unCommit"; // 一定要设置表名称,rateView与实际表关联
ds.Tables.Add(table);
ds.Tables.Add(table_un_commite);
// 添加表中的列
table.Columns.Add("Code", typeof(string));
table.Columns.Add("ErrCode", typeof(string));
table.Columns.Add("Count", typeof(int));
table.Columns.Add("errCount", typeof(int));
table.Columns.Add("rate", typeof(string));
//
table_un_commite.Columns.Add("CodeRange", typeof(string));
table_un_commite.Columns.Add("Count", typeof(int));
// 获取统计数据
int total_count = 0;
int total_err_count = 0;
Dictionary <string, int> dic_waste_code = new Dictionary <string, int>();
Dictionary <string, int> dic_waste_code_boxcollect = new Dictionary <string, int>();
//将连续数据合并
Dictionary <string, int> dic_waste_code_continue = new Dictionary <string, int>();
//未提交的数据，即不连续的数据
List <string> lst_uncommite_code = new List <string>();
//该时间段内起始号
string min_code = "";
//该事件段内终止号
string max_code = "";
if (boxCollect.Count() > 0)
{
min_code = boxCollect[0].head + boxCollect[0].StartCode;
max_code = boxCollect[boxCollect.Count() - 1].head + boxCollect[boxCollect.Count() - 1].EndCode;
}
foreach (D_VerWasteCode data in WasteCode)
{
if (dic_waste_code.ContainsKey(data.codeRange))
{
dic_waste_code[data.codeRange]++;
}
else
{
dic_waste_code.Add(data.codeRange, 0);
if (data.Note != "0")
{
dic_waste_code[data.codeRange]++;
}
}
}
List <string> unique_code = new List <string>();
foreach (D_BoxCollectResult boxcollect in boxCollect)
{
string codeRange = boxcollect.head + boxcollect.StartCode + "-" + boxcollect.head + boxcollect.EndCode;
if (codeRange.Length < 5)
{
continue;
}
if (!dic_waste_code_boxcollect.ContainsKey(codeRange))
{
dic_waste_code_boxcollect.Add(codeRange, -1);
}
foreach (D_VerWasteCode data in WasteCode)
{
string[] s = data.codeRange.Split('-');
if (s.Length == 2)
{
if (String.Compare(s[0], (boxcollect.head + boxcollect.StartCode)) <= 0 && String.Compare(s[1], (boxcollect.head + boxcollect.EndCode)) >= 0)
{
if (dic_waste_code_boxcollect[codeRange] == -1)
{
dic_waste_code_boxcollect[codeRange] = 0;
}
}
}
if (string.Compare(data.code, (boxcollect.head + boxcollect.EndCode)) <= 0 && string.Compare(data.code, (boxcollect.head + boxcollect.StartCode)) >= 0)
{
if (!unique_code.Contains(data.code))
{
unique_code.Add(data.code);
dic_waste_code_boxcollect[codeRange]++;
}
}
}
}
string start_code = "";
string end_code = "";
int code_err_count = 0;
//if(dic_waste_code.Count()<=0)
//{
// string uncommit = min_code + "-" + max_code;
// lst_uncommite_code.Add(uncommit);
//}
//foreach (string key in dic_waste_code.Keys)
//{
// string[] s = key.Split('-');
// if (s.Count() == 2)
// {
// int start_code_tmp = int.Parse(s[0].Substring(2, s[0].Length - 2));
// if (end_code.Length > 2)
// {
// int end_code_tmp = int.Parse(end_code.Substring(2, end_code.Length - 2));
// if (start_code_tmp - end_code_tmp == 1)
// {
// end_code = s[1];
// // code_err_count += dic_waste_code[key];
// }
// else
// {
// string range = start_code + "-" + end_code;
// if (range != "")
// {
// // dic_waste_code_continue.Add(range, code_err_count);
// }
// if (start_code_tmp - end_code_tmp > 1)
// {
// string head = s[0].Substring(0, 2);
// string uncommit = head + (end_code_tmp + 1).ToString("d7") + "-" + head + (start_code_tmp - 1).ToString("d7");
// lst_uncommite_code.Add(uncommit);
// }
// start_code = s[0];
// end_code = s[1];
// // code_err_count = dic_waste_code[key];
// }
// }
// else
// {
// start_code = s[0];
// end_code = s[1];
// if (String.Compare(end_code, max_code) <=0 && String.Compare(start_code, min_code) >= 0 && end_code != "" && max_code != "")
// {
// try
// {
// int tmp = int.Parse(start_code.Substring(2, start_code.Length - 2));
// string uncommit = min_code + "-" + start_code.Substring(0, 2) + (tmp - 1).ToString("d7");
// lst_uncommite_code.Add(uncommit);
// }
// catch (Exception e)
// {
// LogHelper.WriteLog("", e);
// }
// }
// // code_err_count = dic_waste_code[key];
// }
// }
//}
////if (start_code != min_code && start_code != "" && min_code != "")
////{
//// try
//// {
//// int tmp = int.Parse(start_code.Substring(2, start_code.Length - 2));
//// string uncommit = min_code + "-" + start_code.Substring(0,2)+(tmp-1).ToString("d7");
//// lst_uncommite_code.Add(uncommit);
//// }
//// catch(Exception e)
//// {
//// LogHelper.WriteLog("", e);
//// }
////}
//if (String.Compare(end_code,max_code)<0 &&String.Compare(start_code,min_code)>0&& end_code != "" && max_code != "")
//{
// try
// {
// int tmp = int.Parse(end_code.Substring(2, end_code.Length - 2));
// if((tmp+1)%1000000==0)
// {
// tmp = tmp - 1;
// }
// string uncommit = end_code.Substring(0,2)+(tmp+1).ToString("d7") + "-" + max_code;
// lst_uncommite_code.Add(uncommit);
// }
// catch (Exception e)
// {
// LogHelper.WriteLog("", e);
// }
// //string uncommit = end_code + "-" + max_code;
// //lst_uncommite_code.Add(uncommit);
//}
//start_code = "";
//end_code = "";
//code_err_count = 0;
List <string> lst_uncommite_code_tmp = new List <string>();
foreach (string key in dic_waste_code_boxcollect.Keys)
{
string[] s = key.Split('-');
if (s.Count() == 2)
{
if (dic_waste_code_boxcollect[key] == -1)
{
lst_uncommite_code_tmp.Add(key);
continue;
}
int start_code_tmp = 0;
bool ret = int.TryParse(s[0].Substring(2, s[0].Length - 2), out start_code_tmp);
if (!ret)
{
LogHelper.WriteLog("转换错误");
continue;
}
if (end_code.Length > 2)
{
int end_code_tmp = 0;
ret = int.TryParse(end_code.Substring(2, end_code.Length - 2), out end_code_tmp);
if (!ret)
{
LogHelper.WriteLog("转换错误");
continue;
}
if (start_code_tmp - end_code_tmp == 1)
{
end_code = s[1];
code_err_count += dic_waste_code_boxcollect[key] == -1?0:dic_waste_code_boxcollect[key];
}
else
{
string range = start_code + "-" + end_code;
if (range != "")
{
dic_waste_code_continue.Add(range, code_err_count);
}
if (start_code_tmp - end_code_tmp > 1)
{
//string head = s[0].Substring(0, 2);
// string uncommit = head + (end_code_tmp + 1).ToString() + "-" + head + (start_code_tmp - 1).ToString();
// lst_uncommite_code.Add(uncommit);
}
start_code = s[0];
end_code = s[1];
code_err_count = dic_waste_code_boxcollect[key] == -1 ? 0 : dic_waste_code_boxcollect[key];
}
}
else
{
start_code = s[0];
end_code = s[1];
code_err_count = dic_waste_code_boxcollect[key] == -1 ? 0 : dic_waste_code_boxcollect[key];
}
}
}
string range1 = start_code + "-" + end_code;
if (range1 != "" && range1.Trim() != "-")
{
dic_waste_code_continue.Add(range1, code_err_count);
}
start_code = "";
end_code = "";
foreach (string key in lst_uncommite_code_tmp)
{
string[] s = key.Split('-');
if (s.Count() == 2)
{
int start_code_tmp = 0;
bool ret = int.TryParse(s[0].Substring(2, s[0].Length - 2), out start_code_tmp);
if (!ret)
{
LogHelper.WriteLog("转换错误");
continue;
}
if (end_code.Length > 2)
{
int end_code_tmp = 0;
ret = int.TryParse(end_code.Substring(2, end_code.Length - 2), out end_code_tmp);
if (!ret)
{
LogHelper.WriteLog("转换错误");
continue;
}
if (start_code_tmp - end_code_tmp == 1)
{
end_code = s[1];
}
else
{
string range = start_code + "-" + end_code;
if (range != "")
{
lst_uncommite_code.Add(range);
}
start_code = s[0];
end_code = s[1];
}
}
else
{
start_code = s[0];
end_code = s[1];
}
}
}
range1 = start_code + "-" + end_code;
if (range1 != "-" && range1.Trim() != "")
{
lst_uncommite_code.Add(range1);
}
foreach (string key in dic_waste_code_continue.Keys)
//for (int i=0;i<verWasteCode.Count();i++)
{
DataRow row = table.NewRow();
row["Code"] = key;
row["ErrCode"] = "";
int code_count = 0;
string[] s = key.Split('-');
if (s.Count() == 2)
{
try
{
code_count = int.Parse(s[1].Substring(2, s[1].Length - 2)) - int.Parse(s[0].Substring(2, s[0].Length - 2)) + 1;
}
catch (Exception ex)
{
LogHelper.WriteLog("", ex);
}
}
row["Count"] = code_count;
row["errCount"] = dic_waste_code_continue[key];
total_count += code_count;
total_err_count += dic_waste_code_continue[key];
try
{
row["rate"] = (double.Parse(row["errCount"].ToString()) * 100 / code_count).ToString("f4") + "%";
}
catch (Exception ex)
{
LogHelper.WriteLog("", ex);
}
table.Rows.Add(row);
}
foreach (string key in lst_uncommite_code)
{
Int64 code_count = 0;
string[] s = key.Split('-');
if (s.Count() == 2)
{
try
{
Int64 end = 0;
Int64 start = 0;
Char[] bs = s[0].ToCharArray();
foreach (Char b in bs)
{
if (Char.IsLetter(b))
{
start = (start * 10 + b - 'A' + 10);
}
else
{
start = (start * 10 + b - '0');
}
}
bs = s[1].ToCharArray();
foreach (Char b in bs)
{
if (Char.IsLetter(b))
{
end = (end * 10 + b - 'A' + 10);
}
else
{
end = (end * 10 + b - '0');
}
}
// code_count = int.Parse(s[1].Substring(2, s[1].Length - 2)) - int.Parse(s[0].Substring(2, s[0].Length - 2)) + 1;
code_count = end - start + 1;
}
catch (Exception ex)
{
LogHelper.WriteLog("", ex);
}
}
DataRow row = table_un_commite.NewRow();
row["CodeRange"] = key;
row["Count"] = code_count;
table_un_commite.Rows.Add(row);
}
double total_rate = 0.0;
try
{
total_rate = (double)total_err_count / total_count;
}
catch (Exception ex)
{
LogHelper.WriteLog("", ex);
}
report.Parameters[3].Value = (total_rate * 100).ToString("f4") + "%";
report.RegisterData(ds);
report.Preview = prew;
report.Prepare();
report.ShowPrepared();
window.WinFormHost.Child = report.Preview;
return(true);
}
public static IEnumerable GetRootCollection(Model1 db, string collectionPropertyName)
{
PropertyInfo p = db.GetType().GetProperty(collectionPropertyName);
return (IEnumerable)p.GetValue(db);
}
public UserRepository(Model1 context)
{
this.db = context;
}
public LogDetailRepository(Model1 context)
{
this.db = context;
}
public Table1Controller(Model1 db)
{
this.db = db;
}
public CampaniaViewModel()
{
contexto = new Model1();
}
public Redirectable<Model1> GoAfter(Model1 input)
{
return null;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
Mapper.CreateMap <DealCustomerDTO, DealCustomer>();
DealCustomerDTO dealer = new DealCustomerDTO();
try
{
dealer.Name = namebox.Text;
dealer.Email = boxEmail.Text;
dealer.Contact = boxContact.Text;
dealer.Address = boxAddress.Text;
dealer.AddedDate = DateTime.Now;
dealer.AddedBy = UserID;
dealer.Type = comboboxUserType.SelectedItem.ToString();
if (string.IsNullOrWhiteSpace(dealer.Name) ||
string.IsNullOrWhiteSpace(dealer.Email) ||
string.IsNullOrWhiteSpace(dealer.Contact) ||
string.IsNullOrWhiteSpace(dealer.Address) ||
string.IsNullOrWhiteSpace(dealer.Type)
)
{
MessageBox.Show("One or more inputs is incorrect");
return;
}
}
catch (Exception exception)
{
//log the exception later
MessageBox.Show("An error occured please try again");
return;
}
using (var db = new Model1())
{
var dealed = Mapper.Map <DealCustomerDTO, DealCustomer>(dealer);
var id = boxUserID.Text;
if (string.IsNullOrWhiteSpace(id))
{
MessageBox.Show("ID cannot be null or empty");
return;
}
var ids = 0;
int.TryParse(id, out ids);
dealed.id = ids;
db.DealCustomers.AddOrUpdate(dealed);
var result = db.SaveChanges() > 0;
if (result)
{
MessageBox.Show("Input added successfully");
dataUser.DataSource = db.DealCustomers.ToList().ToDataTable();
boxEmail.Clear();
boxAddress.Clear();
boxContact.Clear();
namebox.Clear();
boxUserID.Clear();
}
}
}
private async void btnAdd_Click(object sender, EventArgs e)
{
//create mapper
Mapper.CreateMap <UserDTO, User>();
var users = new UserDTO();
bool tracker = false;
try
{
users.FirstName = boxFirstName.Text;
users.LastName = boxLastName.Text;
users.Email = boxEmail.Text;
users.Address = boxAddress.Text;
users.Contact = boxContact.Text;
users.Gender = comboBoxGender.SelectedItem.ToString();
users.Password = boxPassword.Text;
users.UserName = boxUsername.Text;
users.UserType = comboboxUserType.SelectedItem.ToString();
users.AddedDate = DateTime.Now;
users.AddedBy = userId;
if
(
String.IsNullOrWhiteSpace(users.FirstName) ||
String.IsNullOrWhiteSpace(users.LastName) ||
String.IsNullOrWhiteSpace(users.Password) ||
String.IsNullOrWhiteSpace(users.UserName) ||
String.IsNullOrWhiteSpace(users.Email) ||
String.IsNullOrWhiteSpace(users.Address) ||
String.IsNullOrWhiteSpace(users.Contact) ||
String.IsNullOrWhiteSpace(users.UserType)
)
{
MessageBox.Show("The input field cannot be empty or whitespaces");
return;
}
}
catch (Exception exception)
{
MessageBox.Show("One or more errors occured please check your entries and retry");
return;
}
;
using (var db = new Model1())
{
//mapped entities
var userStored = Mapper.Map <User>(users);
db.Users.Add(userStored);
tracker = await db.SaveChangesAsync() > 0;
}
if (tracker)
{
MessageBox.Show("User Successfully Created");
boxContact.Clear();
boxFirstName.Clear();
boxLastName.Clear();
boxEmail.Clear();
boxAddress.Clear();
boxPassword.Clear();
boxUsername.Clear();
}
else
{
MessageBox.Show("Failed to add new user");
}
}
public ChoppersController(Model1 db)
{
this.db = db;
}
public void OneInZeroOut(Model1 input)
{
LastNameEntered = input.Name;
}
public void post_red_model(Model1 model)
{
}
public void Select_NotNull_DefaultValue()
{
var model = new Model1() { PropInt = 1 };
var helper = new HtmlTagHelper(model);
var name = "PropInt";
var tag = helper.Select(
name,
OptionsList.CreateForEnum<Enum1>(),
defaultValue: 2);
AssertValid(tag, "select", name);
var firstChild = tag.Children.First();
var secondChild = tag.Children.Skip(1).First();
var thirdChild = tag.Children.Skip(2).First();
Assert.Equal("Option1", firstChild.Text());
Assert.True(firstChild.ValueIsEqual(1));
Assert.True(firstChild.HasAttr("selected"));
Assert.Equal("Option2", secondChild.Text());
Assert.True(secondChild.ValueIsEqual(2));
Assert.False(secondChild.HasAttr("selected"));
Assert.Equal("Option3", thirdChild.Text());
Assert.True(thirdChild.ValueIsEqual(3));
Assert.False(thirdChild.HasAttr("selected"));
}
public void post_Blue_model(Model1 model)
{
}
public TeacherRepository(Model1 dbcontext) : base(dbcontext)
{
}
public void B(Model1 model)
{
}
private static void Main(string[] args)
{
var idHtml = ""; //查詢&primaryKey=53413351"
Model1 db = new Model1();
int page = 1;
//int countsid = 0;
bool come = false;
bool savecome = false;
//關鍵字
string setting = ConfigurationSettings.AppSettings["Keyworld"];
//寄信
string ReceiveEmail = "*****@*****.**"; //收信者email
string CaseStr =
@"<table width='100%' border='0' cellspacing='0' cellpadding='0' style='word-break:break-all'>
<tbody><tr>
<th width='5%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>項次 </th>
<th width='15%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>機關 <br>名稱 </th>
<th width='26%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>標案案號 <br>標案名稱 </th>
<th width='5%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>傳輸 <br>次數 </th>
<th width='10%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>招標 <br>方式 </th>
<th width='8%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>採購 <br>性質 </th>
<th width='9%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>公告 <br>日期 </th>
<th width='9%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>截止 <br>投標 </th>
<th width='13%' align='center' bgcolor='#E0EDF1' class='T12b' nowrap=''>預算 <br>金額 </th>
</tr>";
//寄信項次
int counts = 1;
for (int i = 1; i < page + 1; i++)
{
string htmlString =
GetWebContent(
@"https://web.pcc.gov.tw/tps/pss/tender.do?searchMode=common&searchType=basic&isSpdt=&method=search&pageIndex=" +
i);
HtmlDocument htmlDocument = new HtmlDocument();
string htmlStrArranged = htmlString.Replace("\r", "").Replace("\n", "").Replace("\t", "");
htmlDocument.LoadHtml(htmlStrArranged);
HtmlNode htmlNodes = htmlDocument.DocumentNode.SelectSingleNode(
@"html/body/table/tr[2]/td[2]/table[1]/tr[5]/td[1]/table[1]/tr[3]/td[1]/table[1]/tbody[1]/tr[1]/td[1]/div[1]/table[1]");
int a = htmlNodes.LastChild.InnerHtml.LastIndexOf("</b>");
int b = htmlNodes.LastChild.InnerHtml.LastIndexOf("<b>") + 3;
page = int.Parse(
htmlNodes.LastChild.InnerHtml.Substring(b,
a - b));
//循環
foreach (HtmlNode node in htmlNodes.ChildNodes)
{
if (node.SelectNodes("td") != null && !node.SelectNodes("td")[0].InnerHtml.Contains("第一頁") &&
!node.SelectNodes("td")[0].InnerHtml.Contains("無符合條件資料"))
{
if (node.SelectNodes("td")[2].InnerHtml
.Contains(setting) && node.SelectNodes("td")[2].InnerHtml
.Contains("更正公告"))
{
//如果有更正公告一率刪除
string idstr = "&primaryKey=";
idHtml = node.ChildNodes[7].InnerHtml
.Substring(node.ChildNodes[7].InnerHtml.IndexOf(idstr) + idstr.Length, 8);
var countid = db.BidCases.Where(x => x.標案案號標案名稱.Contains(idHtml)).FirstOrDefault();
if (countid != null)
{
db.BidCases.Remove(countid);
db.SaveChanges();
}
}
if (node.SelectNodes("td")[2].InnerHtml
.Contains(setting))
{
var h = db.BidCases.Where(x => x.標案案號標案名稱.Contains(setting));
//之前已經查詢過 必需跟資料庫比對(有資料)
if (h.Count() > 0)
{
come = true;
}
//無資料
else
{
//初始化(沒有查詢過)
BidCase cases = new BidCase(); //屬性
// var first = node.ChildNodes[1].InnerHtml;
cases.項次 = Convert.ToInt16(
node.SelectNodes("td")[0].InnerHtml.Replace(" ", ""));
cases.機關名稱 = node.SelectNodes("td")[1].InnerHtml.Replace(" ", "");
//string str = node.SelectNodes("td")[2].InnerHtml.Substring(node.SelectNodes("td")[2].InnerHtml.IndexOf("<br>"));
//cases.標案案號 = node.SelectNodes("td")[2].InnerHtml.Replace(str, "");
//string str2 = node.SelectNodes("td")[3].InnerHtml.Substring(node.SelectNodes("td")[3].InnerHtml.LastIndexOf("<u>") + 3);
cases.標案案號標案名稱 = node.SelectNodes("td")[2].InnerHtml
.Replace("..", "https://web.pcc.gov.tw/tps").Replace(" ", "");
//cases.傳輸次數 = str2.Replace("</u>", "").Replace(" ", "").Replace("</a>", "");
cases.傳輸次數 = node.SelectNodes("td")[3].InnerHtml
.Replace("..", "https://web.pcc.gov.tw/tps")
.Replace(" ", "");
cases.招標方式 = node.SelectNodes("td")[4].InnerHtml;
cases.採購性質 = node.SelectNodes("td")[5].InnerHtml;
cases.公告日期 = Convert.ToDateTime(node.SelectNodes("td")[6].InnerHtml);
cases.截止投標 = Convert.ToDateTime(node.SelectNodes("td")[7].InnerHtml);
if (node.SelectNodes("td")[8].InnerHtml != "")
{
cases.預算金額 = Convert.ToDecimal(node.SelectNodes("td")[8].InnerHtml);
}
//db名 加入有值屬性
db.BidCases.Add(cases);
//寄信
CaseStr +=
$@"<tr bgcolor='#FFFFFF' onmouseover='overcss(this);' onmouseout='outcss(this,'#FFFFFF');' style='background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);'>
<!-- 項次 -->
<td align='center'>{counts}</td>
<!-- 機關名稱 -->
<td align='left'>{cases.機關名稱}</td>
<!-- 標案案號&標案名稱 -->
<td align='left'>{cases.標案案號標案名稱}
</td>
<!-- 傳輸次數 -->
<td align='center'>{cases.傳輸次數}
</td>
<!-- 招標方式 -->
<td align='left'>{cases.招標方式}</td>
<!-- 標的分類 -->
<td align='left'>{cases.採購性質}</td>
<!-- 公告日期 -->
<td align='left'>{string.Format("{0:yyy/MM/dd}", cases.公告日期)}
</td>
<!-- 截止投標 -->
<td align='left'>{string.Format("{0:yyy/MM/dd}", cases.截止投標)}
</td>
<!-- 預算金額 -->
<td align='right'>{Convert.ToInt64(cases.預算金額)}
</td>
</tr>";
savecome = true;
}
//有資料
if (come)
{
string idstr = "&primaryKey=";
idHtml = node.ChildNodes[7].InnerHtml
.Substring(node.ChildNodes[7].InnerHtml.IndexOf(idstr) + idstr.Length, 8);
var countid = db.BidCases.Any(x => x.標案案號標案名稱.Contains(idHtml));
//id沒有資料才新增資料
if (!countid)
{
BidCase cases = new BidCase(); //屬性
// var first = node.ChildNodes[1].InnerHtml;
cases.項次 = Convert.ToInt16(
node.SelectNodes("td")[0].InnerHtml.Replace(" ", ""));
cases.機關名稱 = node.SelectNodes("td")[1].InnerHtml.Replace(" ", "");
//string str = node.SelectNodes("td")[2].InnerHtml.Substring(node.SelectNodes("td")[2].InnerHtml.IndexOf("<br>"));
//cases.標案案號 = node.SelectNodes("td")[2].InnerHtml.Replace(str, "");
//string str2 = node.SelectNodes("td")[3].InnerHtml.Substring(node.SelectNodes("td")[3].InnerHtml.LastIndexOf("<u>") + 3);
cases.標案案號標案名稱 = node.SelectNodes("td")[2].InnerHtml
.Replace("..", "https://web.pcc.gov.tw/tps").Replace(" ", "");
//cases.傳輸次數 = str2.Replace("</u>", "").Replace(" ", "").Replace("</a>", "");
cases.傳輸次數 = node.SelectNodes("td")[3].InnerHtml
.Replace("..", "https://web.pcc.gov.tw/tps")
.Replace(" ", "");
cases.招標方式 = node.SelectNodes("td")[4].InnerHtml;
cases.採購性質 = node.SelectNodes("td")[5].InnerHtml;
cases.公告日期 = Convert.ToDateTime(node.SelectNodes("td")[6].InnerHtml);
cases.截止投標 = Convert.ToDateTime(node.SelectNodes("td")[7].InnerHtml);
if (node.SelectNodes("td")[8].InnerHtml != "")
{
cases.預算金額 = Convert.ToDecimal(node.SelectNodes("td")[8].InnerHtml);
}
//db名 加入有值屬性
db.BidCases.Add(cases);
CaseStr +=
$@"<tr bgcolor='#FFFFFF' onmouseover='overcss(this);' onmouseout='outcss(this,'#FFFFFF');' style='background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);'>
<!-- 項次 -->
<td align='center'>{counts}</td>
<!-- 機關名稱 -->
<td align='left'>{cases.機關名稱}</td>
<!-- 標案案號&標案名稱 -->
<td align='left'>{cases.標案案號標案名稱}
</td>
<!-- 傳輸次數 -->
<td align='center'>{cases.傳輸次數}
</td>
<!-- 招標方式 -->
<td align='left'>{cases.招標方式}</td>
<!-- 標的分類 -->
<td align='left'>{cases.採購性質}</td>
<!-- 公告日期 -->
<td align='left'>{string.Format("{0:yyy/MM/dd}", cases.公告日期)}
</td>
<!-- 截止投標 -->
<td align='left'>{string.Format("{0:yyy/MM/dd}", cases.截止投標)}
</td>
<!-- 預算金額 -->
<td align='right'>{Convert.ToInt64(cases.預算金額)}
</td>
</tr>";
savecome = true;
}
}
//項次
counts++;
}
}
}
}
if (savecome)
{
db.SaveChanges();
SendEmail(ReceiveEmail, CaseStr + "</table>");
}
Console.WriteLine("結束");
Console.ReadKey();
}
public static IEnumerable GetRootCollection(Model1 db, Type type)
{
return GetRootCollection(db, type.Pluralize());
}
private void Filtr()
{
if (exec.Text.Length != 0 && stat.Text.Length == 0)
{
using (Model1 db = new Model1())
{
lTasks.ItemsSource = null;
string ex = exec.SelectedValue.ToString();
var query = from a in db.Task
join b in db.User on a.ExecutorID equals b.ID
join c in db.Executor on a.ExecutorID equals c.ID
join d in db.User on c.ManagerID equals d.ID
orderby a.Deadline descending
where d.ID.Equals(i) && b.FirstName + b.MiddleName + b.LastName == ex
select new
{
Title = a.Title,
Status = a.Status,
ExecutorFName = b.FirstName,
ExecutorMName = b.MiddleName,
ExecutorLName = b.LastName,
ManagerFName = d.FirstName,
ManagerMName = d.MiddleName,
ManagerLName = d.LastName,
};
lTasks.ItemsSource = query.ToList();
}
}
else if (exec.Text.Length == 0 && stat.Text.Length != 0)
{
using (Model1 db = new Model1())
{
lTasks.ItemsSource = null;
string st = stat.SelectedValue.ToString();
var query = from a in db.Task
join b in db.User on a.ExecutorID equals b.ID
join c in db.Executor on a.ExecutorID equals c.ID
join d in db.User on c.ManagerID equals d.ID
orderby a.Deadline descending
where (b.ID.Equals(i) || d.ID.Equals(i)) && a.Status == st
select new
{
Title = a.Title,
Status = a.Status,
ExecutorFName = b.FirstName,
ExecutorMName = b.MiddleName,
ExecutorLName = b.LastName,
ManagerFName = d.FirstName,
ManagerMName = d.MiddleName,
ManagerLName = d.LastName,
};
lTasks.ItemsSource = query.ToList();
}
}
else if (exec.Text.Length != 0 && stat.Text.Length != 0)
{
using (Model1 db = new Model1())
{
lTasks.ItemsSource = null;
string ex = exec.SelectedValue.ToString();
string st = stat.SelectedValue.ToString();
var query = from a in db.Task
join b in db.User on a.ExecutorID equals b.ID
join c in db.Executor on a.ExecutorID equals c.ID
join d in db.User on c.ManagerID equals d.ID
orderby a.Deadline descending
where d.ID.Equals(i) && b.FirstName + b.MiddleName + b.LastName == ex && a.Status == st
select new
{
Title = a.Title,
Status = a.Status,
ExecutorFName = b.FirstName,
ExecutorMName = b.MiddleName,
ExecutorLName = b.LastName,
ManagerFName = d.FirstName,
ManagerMName = d.MiddleName,
ManagerLName = d.LastName,
};
lTasks.ItemsSource = query.ToList();
}
}
}
public void CheckBoxList_NotNull_DefaultValue()
{
var model = new Model1() { PropIntList = Coll.Array(2, 3) };
var helper = new HtmlTagHelper(model);
var name = "PropIntList";
var tag = helper.CheckBoxList(
name,
OptionsList.CreateForEnum<Enum1>(),
defaultValues: Coll.Array(1, 2, 4));
Assert.Equal(3, tag.Children.Count());
CheckBoxListTagTest.AssertValidOption(tag.Options.Skip(0).First(), name: name, display: "Option1", value: 1, isChecked: false);
CheckBoxListTagTest.AssertValidOption(tag.Options.Skip(1).First(), name: name, display: "Option2", value: 2, isChecked: true);
CheckBoxListTagTest.AssertValidOption(tag.Options.Skip(2).First(), name: name, display: "Option3", value: 3, isChecked: true);
}
public ListTasks(int role, int id)
{
InitializeComponent();
using (Model1 db = new Model1())
{
ro = role;
i = id;
if (ro == 1)
{
var query = from a in db.Task
join b in db.User on a.ExecutorID equals b.ID
join c in db.Executor on a.ExecutorID equals c.ID
join d in db.User on c.ManagerID equals d.ID
orderby a.Deadline descending
where d.ID.Equals(i)
select new
{
Title = a.Title,
Status = a.Status,
ExecutorFName = b.FirstName,
ExecutorMName = b.MiddleName,
ExecutorLName = b.LastName,
ManagerFName = d.FirstName,
ManagerMName = d.MiddleName,
ManagerLName = d.LastName,
};
lTasks.ItemsSource = query.ToList();
}
else
{
var query = from a in db.Task
join b in db.User on a.ExecutorID equals b.ID
join c in db.Executor on a.ExecutorID equals c.ID
join d in db.User on c.ManagerID equals d.ID
orderby a.Deadline descending
where b.ID.Equals(i)
select new
{
Title = a.Title,
Status = a.Status,
ExecutorFName = b.FirstName,
ExecutorMName = b.MiddleName,
ExecutorLName = b.LastName,
ManagerFName = d.FirstName,
ManagerMName = d.MiddleName,
ManagerLName = d.LastName,
};
lTasks.ItemsSource = query.ToList();
exec.Visibility = Visibility.Hidden;
label.Visibility = Visibility.Hidden;
}
List <User> query1 = db.User.ToList();
foreach (User b in query1)
{
if (b.ID < 10)
{
exec.Items.Add(b.FirstName + b.MiddleName + b.LastName);
}
}
stat.Items.Add("запланирована");
stat.Items.Add("исполняется");
stat.Items.Add("выполнена");
stat.Items.Add("отменена");
}
}
public void M1(Model1 input)
{
}
public DanhMucDao()
{
db = new Model1();
}
public UsersRepository(Model1 db)
{
this.db = db;
}
public static IEnumerable RootCollection(string collectionPropertyName)
{
using (var db = new Model1())
{
var col = GetRootCollection(db, collectionPropertyName);
Type generic = typeof(List<>);
Type constructed = generic.MakeGenericType(col.GetType().GetGenericArguments().First());
var list = constructed.GetConstructor(new Type[] { col.GetType() }).Invoke(new object[] { col });
return (IEnumerable)list;
}
}
public Shell(Model1 model1, Model2 model2)
{
Model1 = model1;
Model2 = model2;
}
public IHttpActionResult UploadFile()
{
Model1 entity = new Model1();
try
{
// List<LogResponseDTO> lstErrores = new List<LogResponseDTO>();
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count > 0)
{
var fileSavePath = string.Empty;
var docfiles = new List <string>();
var URLArchivo = "";
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
//var filePath = HttpContext.Current.Server.MapPath("/UploadedFiles/");
var filePath = "C:/UploadedFiles/";
var GUID = Guid.NewGuid().ToString();
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
fileSavePath = Path.Combine(filePath, GUID + "." + postedFile.FileName.Split('.')[1]);
postedFile.SaveAs(fileSavePath);
docfiles.Add(filePath);
URLArchivo = "C:/UploadedFiles/" + GUID + "." + postedFile.FileName.Split('.')[1];
string e = Path.GetExtension(URLArchivo);
if ((e != ".xlsx") && (e != ".xlsm"))
{
return(Ok(new { success = false, message = "La extencion del archivo no es valida" }));
}
}
InstructorBl instructor = new InstructorBl();
var book = new ExcelQueryFactory(URLArchivo);
var hoja = book.GetWorksheetNames();
var resultado = (from i in book.Worksheet(hoja.FirstOrDefault())
select i).ToList();
foreach (var values in resultado)
{
Instructor oInstructor = new Instructor();
var cedula = instructor.ConsultarInstructorCedula(values[2]);
if (cedula == null)
{
oInstructor.Nombre = values[0];
oInstructor.Apellido = values[1];
oInstructor.Cedula = values[2];
oInstructor.Email = values[3];
oInstructor.Estado = true;
oInstructor.Telefono = values[4];
var codigo = int.Parse(values[5]);
var area = (from i in entity.Area
where i.Codigo == codigo
select i).FirstOrDefault();
if (values[6].ToString().ToLower() == "contratista")
{
oInstructor.TipoContrato = "1";
}
else
{
oInstructor.TipoContrato = "2";
}
//oInstructor.IdCompetencia = int.Parse(values[4]);
ProgramaBl oProgramaBl = new ProgramaBl();
// oListaInstructor.Add(oInstructor);
instructor.GuardarInstructor(oInstructor);
}
}
return(Ok(new { success = true, path = URLArchivo, }));
}
else
{
return(Ok(new { success = false, message = "No File" }));
}
}
catch (Exception exc)
{
return(Ok(new { success = false, message = exc.Message }));
}
}
