/// <summary>
/// Zastąpiony przez Workflow
/// </summary>
/// <param name="item"></param>
internal static void Execute(Microsoft.SharePoint.SPListItem item)
{
BLL.Logger.LogEvent("Obsługa kart kontrolnych", item.ID.ToString());
SPList list = item.Web.Lists.TryGetList(targetList);
//ustaw okres karencji
int offset = int.Parse(BLL.admSetup.GetValue(item.Web, "KK_IGNORE_UPDATES_MINUTES"));
DateTime targetDate = DateTime.Now.AddMinutes(-1 * offset);
list.Items.Cast <SPListItem>()
.Where(i => BLL.Tools.Get_Date(i, "Modified") < targetDate) //nie ruszaj modyfikowanych w ciągu istatnicj x minut
.Where(i => BLL.Tools.Get_Text(i, "colZUS_StatusZadania").Equals(_STATUS_ZADANIA_ZWOLNIONE) ||
BLL.Tools.Get_Text(i, "colPD_StatusZadania").Equals(_STATUS_ZADANIA_ZWOLNIONE) ||
BLL.Tools.Get_Text(i, "colVAT_StatusZadania").Equals(_STATUS_ZADANIA_ZWOLNIONE) ||
BLL.Tools.Get_Text(i, "colRBR_StatusZadania").Equals(_STATUS_ZADANIA_ZWOLNIONE))
.ToList()
.ForEach(i =>
{
SPWorkflow wf = BLL.Workflows.StartWorkflow(i, "Przygotuj wiadomość dla klienta");
Debug.WriteLine("StartWorkflow: Przygotuj wiadomość dla klienta " + wf.InternalState.ToString());
BLL.Logger.LogEvent(BLL.Tools.Get_LookupValue(i, "selKlient").ToString(), i.ID.ToString());
});
}
public static void Create(Microsoft.SharePoint.SPListItem item)
{
BLL.Logger.LogEvent("Generowanie formatek rozliczeniowych", item.ID.ToString());
string mask = BLL.Tools.Get_Text(item, "colMaskaSerwisu");
string kmask = BLL.Tools.Get_Text(item, "colMaskaTypuKlienta");
if (!string.IsNullOrEmpty(kmask))
{
if (!string.IsNullOrEmpty(mask))
{
Create_Bulk_FormsBy_KMask_Mask(item, kmask, mask);
}
else
{
Crate_Bulk_FormsBy_KMask(item, kmask);
}
}
else
{
if (!string.IsNullOrEmpty(mask))
{
Create_Bulk_FormsBy_Mask(item, mask);
}
else
{
Crate_Bulk_Forms(item);
}
}
}
public DeleteFolderCommand(int itemID, string listName, SP.SPWeb web)
: base(web)
{
SP.SPList targetList = _web.Lists.TryGetList(listName);
if (targetList == default(SP.SPList)) { throw new Exception(string.Format("Could not find any list with the name {0}", listName)); }
_item = targetList.GetItemByIdSelectedFields(itemID);
}
public DeleteFolderCommand(string folderUrl, SP.SPWeb web)
: base(web)
{
SP.SPFolder folder = _web.GetFolder(folderUrl);
if (!folder.Exists) { throw new Exception(string.Format("Could not find any folder with the url {0}", folder)); }
_item = folder.Item;
}
private static string Create_KEY(Microsoft.SharePoint.SPListItem item)
{
int klientId = Get_LookupId(item, "selKlient");
int okresId = Get_LookupId(item, "selOkres");
return(Create_KEY(klientId, okresId));
}
public UpdateItemCommand(SP.SPListItem item, Dictionary<string, object> properties)
: base()
{
_web = item.Web;
_item = item;
_newPropertiesValues = properties;
BackUpOldPropertiesValues();
}
public UpdateFolderCommand(string folderUrl, Dictionary<string, object> properties, SP.SPWeb web)
: base(web)
{
SP.SPFolder folder = _web.GetFolder(folderUrl);
if (!folder.Exists) { throw new Exception(string.Format("Could not find any folder with the url {0}", folder)); }
_item = folder.Item;
BackUpOldPropertiesValues();
}
public UpdateItemCommand(int itemID, string listName, Dictionary<string, object> properties, SP.SPWeb web)
: base(web)
{
SP.SPList targetList = _web.Lists.TryGetList(listName);
if (targetList == default(SP.SPList)) { throw new Exception(string.Format("Could not find any list with the name {0}", listName)); }
_item = targetList.GetItemByIdSelectedFields(itemID, properties.Keys.ToArray());
BackUpOldPropertiesValues();
}
public UpdateFolderCommand(SP.SPFolder folder, Dictionary<string, object> properties)
: base()
{
_web = folder.ParentWeb;
_item = folder.Item;
_newPropertiesValues = properties;
BackUpOldPropertiesValues();
}
internal static string Get_ItemInfo(Microsoft.SharePoint.SPListItem item)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("CT=" + item.ContentType.Name);
sb.AppendLine("ID=" + item.ID.ToString());
return(sb.ToString());
}
public static void Update_PD_Data(Microsoft.SharePoint.SPListItem item)
{
string KEY = Create_KEY(item);
int formId = Get_KartaKontrolnaId(item, KEY);
SPListItem form = Get_KartaKontrolnaById(item.Web, formId);
Copy_PDFields(item, form);
form.SystemUpdate();
}
/// <summary>
/// How to get attachement URL programatically
/// </summary>
/// <param name="oItem"></param>
/// <returns></returns>
//public static string GetAttachmentUrls(Microsoft.SharePoint.SPListItem oItem)
//{
// string path = string.Empty;
// try
// {
// path = (from string file in oItem.Attachments
// orderby file
// select SPUrlUtility.CombineUrl(oItem.Attachments.UrlPrefix, file)).FirstOrDefault();
// return path;
// }
// catch
// {
// return string.Empty;
// }
//}
public static string GetAttachmentUrl(Microsoft.SharePoint.SPListItem oItem, string attName)
{
string url = string.Empty;
try
{
url = SPUrlUtility.CombineUrl(oItem.Attachments.UrlPrefix, attName);
}
catch (Exception)
{}
return(url);
}
private static void Create_New_GFR_K(Microsoft.SharePoint.SPListItem item, string mask, SPList list, SPListItem klientItem)
{
string ct = "Generowanie formatek rozliczeniowych dla klienta";
int okresId = BLL.Tools.Get_LookupId(item, "selOkres");
SPListItem newItem = list.AddItem();
newItem["ContentType"] = ct;
newItem["selKlient"] = klientItem.ID;
newItem["selOkres"] = okresId;
newItem["colMaskaSerwisu"] = mask;
newItem.SystemUpdate();
}
/// <summary>
/// kopiowanie wartości PD na kartę kontrolną
/// </summary>
private static void Copy_PDFields(Microsoft.SharePoint.SPListItem item, SPListItem form)
{
Copy_Field(item, form, "colPotwierdzenieOdbioruDokumento");
Copy_Field(item, form, "colFormaOpodatkowaniaPD");
Copy_Field(item, form, "enumRozliczeniePD");
Copy_Field(item, form, "colPD_OcenaWyniku");
Copy_Field(item, form, "colPD_WartoscDochodu");
Copy_Field(item, form, "colPD_WartoscDoZaplaty");
//Copy_Field(item, form, "colPD_WartoscStraty");
Copy_Field(item, form, "colPD_WartoscStraty", -1);
Copy_Field(item, "selOperator", form, "selOperator_PD");
Copy_Field(item, "colUwagi", form, "Uwagi_PD");
Copy_Field(item, "colNieWysylajDoKlienta", form, "_NieWysylajDoKlienta_PD");
Copy_Id(item, form, "_ZadanieID_PD");
}
private static void Create_New_GFR_K(Microsoft.SharePoint.SPListItem item, string mask, SPList list, SPListItem klientItem)
{
string ct = "Generowanie formatek rozliczeniowych dla klienta";
int okresId = BLL.Tools.Get_LookupId(item, "selOkres");
SPListItem newItem = list.AddItem();
newItem["ContentType"] = ct;
newItem["selKlient"] = klientItem.ID;
newItem["selOkres"] = okresId;
newItem["colMaskaSerwisu"] = mask;
newItem.SystemUpdate();
SPWorkflow wf = BLL.Workflows.StartWorkflow(newItem, "Generuj formatki rozliczeniowe dla klienta");
Debug.WriteLine("StartWorkflow: Generuj formatki rozliczeniowe dla klienta " + wf.InternalState.ToString());
}
public static void Create(Microsoft.SharePoint.SPListItem item)
{
try
{
BLL.Logger.LogEvent("Generowanie formatek rozliczeniowych", item.ID.ToString());
string mask = BLL.Tools.Get_Text(item, "colMaskaSerwisu");
string kmask = BLL.Tools.Get_Text(item, "colMaskaTypuKlienta");
if (!string.IsNullOrEmpty(kmask))
{
if (!string.IsNullOrEmpty(mask))
{
Create_Bulk_FormsBy_KMask_Mask(item, kmask, mask);
}
else
{
Crate_Bulk_FormsBy_KMask(item, kmask);
}
}
else
{
if (!string.IsNullOrEmpty(mask))
{
Create_Bulk_FormsBy_Mask(item, mask);
}
else
{
Crate_Bulk_Forms(item);
}
}
#if DEBUG
BLL.Tools.Set_Text(item, "enumStatusZlecenia", "Zakończony");
item.SystemUpdate();
#else
item.Delete();
#endif
}
catch (Exception ex)
{
BLL.Logger.LogError(item.Web.Name, item.ID.ToString(), ex);
}
}
private static void Copy_PDFields(Microsoft.SharePoint.SPListItem item, SPListItem form)
{
Copy_Field(item, form, "colPotwierdzenieOdbioruDokumento");
Copy_Field(item, form, "colFormaOpodatkowaniaPD");
Copy_Field(item, form, "enumRozliczeniePD");
Copy_Field(item, form, "colPD_OcenaWyniku");
Copy_Field(item, form, "colPD_WartoscDochodu");
Copy_Field(item, form, "colPD_WartoscDoZaplaty");
Copy_Field(item, form, "colPD_WartoscStraty");
Copy_Field(item, "selOperator", form, "selOperator_PD");
Copy_Field(item, "colNotatka", form, "colUwagiPD");
Copy_Id(item, form, "selZadanie_PD");
Copy_Field(item, form, "colPD_TerminPlatnosciPodatku");
Copy_Id(item, form, "selZadanie_PD");
Copy_Field(item, "enumStatusZadania", form, "colPD_StatusZadania");
BLL.Tools.Set_Text(form, "colPD_StatusWysylki", string.Empty);
}
/// <summary>
/// Inicjuje rekordy rozliczenia wspólników spółek na podstawia aktualnej konfiguracji klienta w kartotece.
/// </summary>
public static void Ensure_RecordInitiated(Microsoft.SharePoint.SPWeb web, Microsoft.SharePoint.SPListItem powiazanieItem, int klientId, int okresId)
{
int wspolnikId = BLL.Tools.Get_LookupId(powiazanieItem, "selKlient");
Debug.WriteLine("tab.DochowyWspolnikow.Ensure_RecordInitiated, powiązanieId=" + powiazanieItem.ID.ToString());
int result = 0;
SPList list = web.Lists.TryGetList(targetList);
string key = Define_KEY(klientId, wspolnikId, okresId);
SPListItem item = list.Items.Cast <SPListItem>()
.Where(i => BLL.Tools.Get_Text(i, "KEY").Equals(key))
.FirstOrDefault();
if (item != null)
{
result = item.ID;
}
else
{
//create new record
SPListItem newItem = list.AddItem();
newItem["KEY"] = key;
newItem["selKlient"] = wspolnikId;
newItem["selOkres"] = okresId;
newItem["selKlient_NazwaSkrocona"] = klientId;
newItem["colPD_UdzialWZysku"] = BLL.Tools.Get_Value(powiazanieItem, "colPD_UdzialWZysku");
newItem.Update();
result = newItem.ID;
}
}
protected void AddElementToList()
{
if (string.IsNullOrEmpty(_subfolder)) { _item = _list.AddItem(_subfolder, SP.SPFileSystemObjectType.File); }
else { _item = _list.AddItem(); }
}
internal static void Create_RB_Form(Microsoft.SharePoint.SPWeb web, int okresId, Microsoft.SharePoint.SPListItem klientItem, BLL.Models.Klient iok)
{
if (BLL.Tools.Has_SerwisAssigned(klientItem, "selSewisy", "RB")) //ograniczony dostęp do tablicy rozliczeń gotówkowych
{
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite eSite = new SPSite(web.Site.ID))
{
using (SPWeb eWeb = eSite.OpenWeb())
{
string key = BLL.tabRozliczeniaGotowkowe.Define_KEY(klientItem.ID, okresId);
if (BLL.tabRozliczeniaGotowkowe.Check_KEY_IsAllowed(key, web, 0))
{
BLL.tabRozliczeniaGotowkowe.Create_ctRB_Form(web, klientItem.ID, okresId, key, klientItem, iok);
}
}
}
});
}
}
private static int Get_LookupId(Microsoft.SharePoint.SPListItem item, string col)
{
return(item[col] != null ? new SPFieldLookupValue(item[col].ToString()).LookupId : 0);
}
public static void Create(Microsoft.SharePoint.SPListItem item)
{
BLL.Logger.LogEvent_Procedure("GFR_K_Request.Create", item, "start");
int okresId = BLL.Tools.Get_LookupId(item, "selOkres");
int klientId = BLL.Tools.Get_LookupId(item, "selKlient");
string mask = BLL.Tools.Get_Text(item, "colMaskaSerwisu");
if (okresId > 0 && klientId > 0)
{
BLL.Models.Klient iok = new BLL.Models.Klient(item.Web, klientId);
SPListItem klientItem = BLL.tabKlienci.Get_KlientById(item.Web, klientId);
int formId = BLL.tabKartyKontrolne.Ensure_KartaKontrolna(item.Web, klientId, okresId, iok);
switch (iok.TypKlienta)
{
case "KPiR":
if (mask.StartsWith("ZUS-") || string.IsNullOrEmpty(mask))
{
ZUS_Forms.Manage_ZUS_Form(item.Web, okresId, klientItem, iok);
}
if (mask.StartsWith("PD-") || string.IsNullOrEmpty(mask))
{
PD_Forms.Create_PD_Form(item.Web, okresId, klientItem, iok);
}
if (mask.StartsWith("VAT-") || string.IsNullOrEmpty(mask))
{
VAT_Forms.Create_VAT_Form(item.Web, okresId, klientItem, iok);
}
if (mask.Equals("RBR") || string.IsNullOrEmpty(mask))
{
RBR_Forms.Create_RBR_Form(item.Web, okresId, klientItem, iok);
}
if (mask.Equals("RB") || string.IsNullOrEmpty(mask))
{
RB_Forms.Create_RB_Form(item.Web, okresId, klientItem, iok);
}
break;
case "KSH":
if (mask.StartsWith("ZUS-") || string.IsNullOrEmpty(mask))
{
ZUS_Forms.Manage_ZUS_Form(item.Web, okresId, klientItem, iok);
}
if (mask.StartsWith("PDS-") || string.IsNullOrEmpty(mask))
{
PDS_Forms.Create_PDS_Form(item.Web, okresId, klientItem, iok);
}
if (mask.StartsWith("VAT-") || string.IsNullOrEmpty(mask))
{
VAT_Forms.Create_VAT_Form(item.Web, okresId, klientItem, iok);
}
if (mask.Equals("RBR") || string.IsNullOrEmpty(mask))
{
RBR_Forms.Create_RBR_Form(item.Web, okresId, klientItem, iok);
}
break;
case "Firma":
if (mask.StartsWith("PD-") || string.IsNullOrEmpty(mask))
{
PD_Forms.Create_PD_Form(item.Web, okresId, klientItem, iok);
}
if (mask.StartsWith("VAT-") || string.IsNullOrEmpty(mask))
{
VAT_Forms.Create_VAT_Form(item.Web, okresId, klientItem, iok);
}
break;
case "Osoba fizyczna":
if (mask.StartsWith("ZUS-") || string.IsNullOrEmpty(mask))
{
ZUS_Forms.Manage_ZUS_Form(item.Web, okresId, klientItem, iok);
}
if (mask.StartsWith("PD-") || string.IsNullOrEmpty(mask))
{
PD_Forms.Create_PD_Form(item.Web, okresId, klientItem, iok);
}
break;
default:
break;
}
}
BLL.Logger.LogEvent_Procedure("GFR_K_Request.Create", item, "end");
}
public DeleteFolderCommand(SP.SPListItem item)
: base()
{
_web = item.Web;
_item = item;
}