public static string Add(Errorlogs errorlogs) { try { using (MySqlConnection conn = new MySqlConnection(connectionString)) { MySqlCommand cmd = new MySqlCommand("SP_Add_Errorlogs", conn); cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add("ErrorLogId", MySqlDbType.Int32).Value = errorlogs.ErrorLogId; cmd.Parameters.Add("Message", MySqlDbType.VarChar).Value = errorlogs.Message; cmd.Parameters.Add("SourceStackTrace", MySqlDbType.VarChar).Value = errorlogs.SourceStackTrace; cmd.Parameters.Add("Parameters", MySqlDbType.VarChar).Value = errorlogs.Parameters; cmd.Parameters.Add("ActionName", MySqlDbType.VarChar).Value = errorlogs.ActionName; cmd.Parameters.Add("PageName", MySqlDbType.VarChar).Value = errorlogs.PageName; cmd.Parameters.Add("URL", MySqlDbType.VarChar).Value = errorlogs.URL; cmd.Parameters.Add("AppId", MySqlDbType.VarChar).Value = errorlogs.AppId; cmd.Parameters.Add("IPAddress", MySqlDbType.VarChar).Value = errorlogs.IpAddress; // cmd.Parameters.Add("CreatedDate", MySqlDbType.DateTime).Value = errorlogs.CreatedDate; cmd.Parameters.Add("CreatedBy", MySqlDbType.VarChar).Value = errorlogs.CreatedBy; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } catch { throw; } return("success"); }
/// <summary> /// /// </summary> /// <param name="webApplicationURL">The web application url</param> /// <param name="listTitle">The list title</param> public static async Task StartSubscription(string webApplicationURL, string listTitle) { using (ClientContext context = new ClientContext(webApplicationURL)) { try { context.Credentials = new NetworkCredential(CommonVariables.AccountName, CommonVariables.Password, "NRES"); List list = context.Web.Lists.GetByTitle(listTitle); CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='IsSubscribeDone' /><Value Type='Boolean'>0</Value></Eq></Where></Query><RowLimit>100</RowLimit></View>"; //camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>68</Value></Eq></Where></Query><RowLimit>100</RowLimit></View>"; ListItemCollection listItems = list.GetItems(camlQuery); context.Load(listItems, items => items.Include( item => item["ID"], item => item["Title"], item => item["InvID"], item => item["IsSubscribeDone"], item => item["Items"], item => item["DocumentID"], item => item["Jurisdiction"], item => item["DocumentAuthor"], item => item["Notes"], item => item["Author"], item => item["SiteUrl"])); context.ExecuteQuery(); await ReadSubscriptionItemCollection(context, listItems, webApplicationURL); } catch (Exception ex) { Errorlogs.Log(context, new ErrorLogItem { ErrorMessage = ex.Message, MethodName = "Program.StartSubscription", StackTrace = ex.StackTrace, SubscriptionID = 0 }); } } }
public static string Add(Errorlogs errorlogs) { return(DALErrorlogs.Add(errorlogs)); }
/// <summary> /// /// </summary> /// <param name="context"></param> /// <param name="listItems"></param> public static async Task ReadSubscriptionItemCollection(ClientContext context, ListItemCollection listItems, string webApplicationURL) { string targetSiteCollectionUrl = string.Empty; foreach (var listItem in listItems) { try { int subscriptionID = Convert.ToInt32(listItem["ID"]); string Itemcoll = listItem["Items"]?.ToString(); string inventoryID = listItem["InvID"]?.ToString(); int DocumentID = Convert.ToInt32(listItem["DocumentID"]?.ToString()); targetSiteCollectionUrl = listItem["SiteUrl"]?.ToString(); FieldUserValue createdBy = (FieldUserValue)listItem["Author"]; var reqItemcoll = Newtonsoft.Json.JsonConvert.DeserializeObject <ReqItemcollection>(Itemcoll); // parse as array SubscriptionItem subscriptionItem = new SubscriptionItem { ID = subscriptionID, InvID = inventoryID, DocumentAuthor = listItem["DocumentAuthor"]?.ToString(), DocumentID = DocumentID, Notes = listItem["Notes"]?.ToString(), WebApplicationURL = webApplicationURL, IsSuccess = 0, Jurisdiction = listItem["Jurisdiction"]?.ToString(), CreatedBy = createdBy }; using (ClientContext targetContext = new ClientContext(targetSiteCollectionUrl)) { targetContext.Credentials = new NetworkCredential(CommonVariables.AccountName, CommonVariables.Password, "NRES"); subscriptionItem.WebApplicationURL = targetSiteCollectionUrl; Requirement.RequirementInventoryUpdate(targetContext, reqItemcoll, subscriptionItem, networkCredential); var checkRemoveDoc = reqItemcoll.reqitems.FindAll(i => i.Isselected == false); if (checkRemoveDoc.Count > 0) { DocumentItem.DocumentInventoryUpdate(targetContext, DocumentID, subscriptionItem, networkCredential, true); } else { DocumentItem.DocumentInventoryUpdate(targetContext, DocumentID, subscriptionItem, networkCredential, false); } await ClientLogFolder.ClientLogFolderCreation(targetContext, reqItemcoll, subscriptionItem); } listItem["IsSubscribeDone"] = subscriptionItem.IsSuccess; listItem.Update(); context.ExecuteQuery(); } catch (Exception ex) { Errorlogs.Log(context, new ErrorLogItem { ErrorMessage = ex.Message, MethodName = "Program.ReadSubscriptionItemCollection", StackTrace = ex.StackTrace, SubscriptionID = Convert.ToInt32(listItem["ID"]) }); } } }