public static string Muhasebelestir(string quoteId)
{
string result = "false";
try
{
IOrganizationService service = MSCRM.AdminOrgService;
Entity quote = service.Retrieve("quote", new Guid(quoteId), new ColumnSet("customerid", "new_financialaccountid", "transactioncurrencyid"));
EntityReference customer = quote.Attributes.Contains("customerid") ? (EntityReference)quote["customerid"] : null;
EntityReference financialAccount = quote.Attributes.Contains("new_financialaccountid") ? (EntityReference)quote["new_financialaccountid"] : null;
EntityReference currency = quote.Attributes.Contains("transactioncurrencyid") ? (EntityReference)quote["transactioncurrencyid"] : null;
string customerName = customer.Name;
SqlDataAccess sda = new SqlDataAccess();
sda.openConnection(Globals.ConnectionString);
#region | UPDATE FINANCIAL ACCOUNT CODE -VOLKAN 08.03.2015 |
if (!string.IsNullOrEmpty(customerName) && financialAccount != null && !financialAccount.Name.Contains("329") && currency != null)
{
char character = customerName[0];
MsCrmResultObject fAccountResult = FinancialAccountHelper.GetFinancialAccountNumberByCharacter(character, sda);
if (fAccountResult.Success)
{
int fAccountCode = (int)fAccountResult.ReturnObject;
fAccountCode++;
string fAccountCodeLeft = fAccountCode.ToString().PadLeft(5, '0');
Entity fAccount = new Entity("new_financialaccount");
fAccount["new_financialaccountid"] = financialAccount.Id;
fAccount["new_financialaccountnumber"] = fAccountCode;
fAccount["new_financialaccountcharacter"] = character + "";
fAccount["new_name"] = "329CA20" + (currency.Name == "TL" ? "TRL" : (currency.Name == "Euro" ? "EUR" : currency.Name)) + character + fAccountCodeLeft;
service.Update(fAccount);
}
else
{
throw new Exception(fAccountResult.Result);
}
}
#endregion
#region | SET GROUP CODE |
if (customer.LogicalName == "contact")
{
if (!string.IsNullOrEmpty(customerName) && !ContactHelper.CheckContactHasGroupCode(customer.Id, sda).Success)
{
char character = customerName[0];
MsCrmResultObject groupCodeResult = ContactHelper.GetContactGroupCodeByCharacter(character, sda);
if (groupCodeResult.Success)
{
int groupCode = (int)groupCodeResult.ReturnObject;
groupCode++;
string groupCodeLeft = groupCode.ToString().PadLeft(4, '0');
Entity entContact = new Entity("contact");
entContact["contactid"] = customer.Id;
entContact["new_groupcodenumber"] = groupCode;
entContact["new_groupcodecharacter"] = character + "";
entContact["new_groupcode"] = "CRM" + "-" + character + groupCodeLeft;
service.Update(entContact);
}
else
{
throw new Exception(groupCodeResult.Result);
}
}
}
if (customer.LogicalName == "account")
{
if (!string.IsNullOrEmpty(customerName) && !AccountHelper.CheckAccountHasGroupCode(customer.Id, sda).Success)
{
char character = customerName[0];
MsCrmResultObject groupCodeResult = AccountHelper.GetAccountGroupCodeByCharacter(character, sda);
if (groupCodeResult.Success)
{
int groupCode = (int)groupCodeResult.ReturnObject;
groupCode++;
string groupCodeLeft = groupCode.ToString().PadLeft(4, '0');
Entity entAccount = new Entity("account");
entAccount["accountid"] = customer.Id;
entAccount["new_groupcodenumber"] = groupCode;
entAccount["new_groupcodecharacter"] = character + "";
entAccount["new_groupcode"] = "CRM" + "-" + character + groupCodeLeft;
service.Update(entAccount);
}
else
{
throw new Exception(groupCodeResult.Result);
}
}
}
#endregion
#region | QUERY UPDATE STATUS|
string sqlQuery = @"UPDATE
Quote
SET
StatusCode=@StatusCode,
ModifiedOn=GETUTCDATE()
WHERE
QuoteId='{0}'" ;
#endregion
sda.ExecuteNonQuery(string.Format(sqlQuery, quoteId), new SqlParameter[] { new SqlParameter("StatusCode", (int)QuoteStatus.MuhasebeyeAktarıldı) });
#region | QUERY UPDATE LOGO TRANSFER |
sqlQuery = string.Empty;
sqlQuery = @"UPDATE
Quote
SET
new_islogotransferred=@Islogotransferred
WHERE
QuoteId='{0}'" ;
#endregion
sda.ExecuteNonQuery(string.Format(sqlQuery, quoteId), new SqlParameter[] { new SqlParameter("Islogotransferred", 1) });
result = "true";
}
catch (Exception)
{
result = "false";
}
return(result);
}