public void ShouldCopyItem()
{
// arrange
using (var db = new Db
{
new DbItem("old root")
{
new DbItem("item") { { "Title", "Welcome!" } }
},
new DbItem("new root")
})
{
var item = db.GetItem("/sitecore/content/old root/item");
var newRoot = db.GetItem("/sitecore/content/new root");
// act
var copy = item.CopyTo(newRoot, "new item");
// assert
db.GetItem("/sitecore/content/new root/new item").Should().NotBeNull();
db.GetItem("/sitecore/content/new root").Children["new item"].Should().NotBeNull();
db.GetItem("/sitecore/content/old root/item").Should().NotBeNull();
db.GetItem("/sitecore/content/old root").Children["item"].Should().NotBeNull();
copy["Title"].Should().Be("Welcome!");
}
}
public void Create_ShouldReturnNewsRepository(NewsRepositoryFactory factory, Db db, string itemName, ID itemId)
{
db.Add(new DbItem(itemName, itemId, Templates.NewsFolder.ID));
var contextItem = db.GetItem(itemId);
var repo = factory.Create(contextItem);
repo.Should().BeAssignableTo<INewsRepository>();
}
public void TestIfInvalidConnectionString()
{
var db = new Db();
db.ConString = "Server=localhosts;Database=testdb;Uid=root;Pwd=;";//erroneous
db.Connect();
Assert.AreEqual(db.IsConnected(), false);
}
public void GetActive_ShouldReturnLanguageModelForContextLanguage(Db db, [Content]DbItem item)
{
var contextItem = db.GetItem(item.ID);
Sitecore.Context.Item = contextItem;
var activeLanguage = LanguageRepository.GetActive();
activeLanguage.TwoLetterCode.Should().BeEquivalentTo(Context.Language.Name);
}
public void ShouldNotOverrideStatisticsIfSetExplicitly()
{
// arrange
const string Created = "20080407T135900";
const string CreatedBy = @"sitecore\admin";
const string Revision = "17be5e4c-19ac-4a67-b582-d72eaa761b1c";
const string Updated = "20140613T111309:635382547899455734";
const string UpdatedBy = @"sitecore\editor";
// act
using (var db = new Db
{
new DbItem("Home")
{
{ "__Created", Created }, { "__Created by", CreatedBy },
{ "__Revision", Revision },
{ "__Updated", Updated }, { "__Updated by", UpdatedBy }
}
})
{
var item = db.GetItem("/sitecore/content/home");
// assert
item["__Created"].Should().Be(Created);
item["__Created by"].Should().Be(CreatedBy);
item["__Revision"].Should().Be(Revision);
item["__Updated"].Should().Be(Updated);
item["__Updated by"].Should().Be(UpdatedBy);
}
}
public void LazyLoading_LazyDisabledGettingParent_ReturnsConcrete()
{
//Arrange
using (Db database = new Db
{
new Sitecore.FakeDb.DbItem("Parent") {
new Sitecore.FakeDb.DbItem("Target")
}
})
{
var context = Context.Create(Utilities.CreateStandardResolver());
var fluent = new SitecoreFluentConfigurationLoader();
var parentConfig = fluent.Add<Stub2>();
var lazy1Config = fluent.Add<Stub1>();
lazy1Config.Parent(x => x.Stub2).IsNotLazy();
context.Load(fluent);
var service = new SitecoreService(database.Database, context);
//Act
var target = service.GetItem<Stub1>("/sitecore/content/parent/target");
var parent = target.Stub2;
//Assert
Assert.AreEqual(typeof(Stub2), parent.GetType());
Assert.True(parent is Stub2);
}
}
protected void ViewAreaRefresh(int taskid)
{
Db obj = new Db();
string sql = string.Format("SELECT TestCaseArea.AreaId, TestCaseArea.AreaName, Task.TaskName FROM Task INNER JOIN TestCaseArea ON Task.TaskId = TestCaseArea.TaskId where Task.TaskId = {0} ", taskid);
GvViewArea.DataSource = obj.fetch(sql);
GvViewArea.DataBind();
}
public DataSourceInfo(Db db)
{
using (DbConnectionInfo cn = db.CreateConnection())
{
DataTable dt = cn.GetSchema("DataSourceInformation");
DataRow dr = dt.Rows[0];
CompositeIdentifierSeparatorPattern = dr["CompositeIdentifierSeparatorPattern"].IfNull(String.Empty);
CompositeIdentifierSeparatorPattern = dr["CompositeIdentifierSeparatorPattern"].IfNull(String.Empty);
DataSourceProductName = dr["DataSourceProductName"].IfNull(String.Empty);
DataSourceProductVersion = dr["DataSourceProductVersion"].IfNull(String.Empty);
GroupByBehavior = (GroupByBehavior)dr["GroupByBehavior"].IfNull(GroupByBehavior.Unknown);
DataSourceProductVersionNormalized = dr["DataSourceProductVersionNormalized"].IfNull(String.Empty);
IdentifierCase = (IdentifierCase)dr["IdentifierCase"].IfNull(IdentifierCase.Unknown);
IdentifierPattern = dr["IdentifierPattern"].IfNull(String.Empty);
OrderByColumnsInSelect = dr["OrderByColumnsInSelect"].IfNull(false);
ParameterMarkerFormat = dr["ParameterMarkerFormat"].IfNull(String.Empty);
ParameterMarkerPattern = dr["ParameterMarkerPattern"].IfNull(String.Empty);
ParameterNameMaxLength = dr["ParameterNameMaxLength"].IfNull(0);
ParameterNamePattern = dr["ParameterNamePattern"].IfNull(String.Empty);
QuotedIdentifierCase = (IdentifierCase)dr["QuotedIdentifierCase"].IfNull(IdentifierCase.Unknown);
QuotedIdentifierPattern = dr["QuotedIdentifierPattern"].IfNull(String.Empty);
StatementSeparatorPattern = dr["StatementSeparatorPattern"].IfNull(String.Empty);
StringLiteralPattern = dr["StringLiteralPattern"].IfNull(String.Empty);
SupportedJoinOperators = (SupportedJoinOperators)dr["SupportedJoinOperators"].IfNull(SupportedJoinOperators.None);
}
}
public void ShouldBeAbleToSetLayoutFieldValue()
{
ID itemId = ID.NewID;
using (var db = new Db
{
new DbItem("page", itemId)
{
new DbField(FieldIDs.LayoutField)
{
Value = "<r/>"
}
}
})
{
DbItem fakeItem = db.DataStorage.GetFakeItem(itemId);
Assert.Equal("<r/>", fakeItem.Fields[FieldIDs.LayoutField].Value);
var item = db.GetItem("/sitecore/content/page");
var layoutField = item.Fields[FieldIDs.LayoutField];
Assert.Equal("<r/>", layoutField.Value);
Assert.Equal("<r/>", item[FieldIDs.LayoutField]);
Assert.Equal("<r/>", item["__Renderings"]);
Assert.Equal("<r/>", LayoutField.GetFieldValue(item.Fields[FieldIDs.LayoutField]));
}
}
public IEnumerable<SalesOrderHeader> AllCompiled()
{
using (var db = new Db(ConnectionString))
{
return compiledAll(db).ToList();
}
}
public void Deserialize_DeserializesNewItem()
{
using (var db = new Db())
{
var deserializer = CreateTestDeserializer(db);
var item = new FakeItem(
id: Guid.NewGuid(),
parentId: ItemIDs.ContentRoot.Guid,
templateId: _testTemplateId.Guid,
versions: new[]
{
new FakeItemVersion(1, "en", new FakeFieldValue("Hello", fieldId: _testVersionedFieldId.Guid))
});
var deserialized = deserializer.Deserialize(item);
Assert.NotNull(deserialized);
var fromDb = db.GetItem(new ID(item.Id));
Assert.NotNull(fromDb);
Assert.Equal("Hello", fromDb[_testVersionedFieldId]);
Assert.Equal(item.ParentId, fromDb.ParentID.Guid);
Assert.Equal(item.TemplateId, fromDb.TemplateID.Guid);
}
}
public SalesOrderHeader GetCompiled(int id)
{
using (var db = new Db(ConnectionString))
{
return compiledGet(db, id);
}
}
public IEnumerable<SalesOrderHeader> All()
{
using (var db = new Db(ConnectionString))
{
return db.SalesOrderHeader.ToList();
}
}
public void Execute_EnforeTemplateOnlyDoesNotInheritTemplate_AbortsPipeline()
{
//Arrange
var task = new EnforcedTemplateCheck();
using (Db database = new Db
{
new DbTemplate(new ID(TemplateInferredTypeTaskFixture.StubInferred.TemplateId)),
new Sitecore.FakeDb.DbItem("Target", ID.NewID, new ID(TemplateInferredTypeTaskFixture.StubInferred.TemplateId))
})
{
var path = "/sitecore/content/Target";
var item = database.GetItem(path);
var config = new SitecoreTypeConfiguration();
config.EnforceTemplate = SitecoreEnforceTemplate.Template;
config.TemplateId = new ID(Guid.NewGuid());
var typeContext = new SitecoreTypeCreationContext();
typeContext.Item = item;
var args = new ObjectConstructionArgs(null, typeContext, config, null, new ModelCounter());
//Act
task.Execute(args);
//Assert
Assert.IsNull(args.Result);
}
}
protected void ViewMaterialsRefresh(int taskid)
{
Db obj = new Db();
string sql = string.Format("SELECT Material.MaterialName, Material.Description, Material.Filepath, Task.TaskName, Material.MaterialId FROM Material INNER JOIN Task ON Material.TaskId = Task.TaskId where Task.TaskId = {0} ", taskid);
GridView1.DataSource = obj.fetch(sql);
GridView1.DataBind();
}
public void ShouldNotUpdateOriginalItemOnEditing()
{
// arrange
using (var db = new Db
{
new DbItem("old root")
{
new DbItem("item") { new DbField("Title") { { "en", 1, "Hi!" } }, }
},
new DbItem("new root")
})
{
var item = db.GetItem("/sitecore/content/old root/item");
var newRoot = db.GetItem("/sitecore/content/new root");
var copy = item.CopyTo(newRoot, "new item");
// act
using (new EditContext(copy))
{
copy["Title"] = "Welcome!";
}
// assert
db.GetItem(copy.ID)["Title"].Should().Be("Welcome!");
db.GetItem(item.ID)["Title"].Should().Be("Hi!");
}
}
public void GetSupportedLanguages_ShouldReturlListOfSupportedLanguages(Db db, DbItem item , string rootName)
{
var contextItemId = ID.NewID;
var rootId = ID.NewID;
var template = new DbTemplate();
template.BaseIDs = new[]
{
Foundation.Multisite.Templates.Site.ID,
Templates.LanguageSettings.ID
};
var languageItem = new DbItem("en");
db.Add(languageItem);
db.Add(new DbTemplate(Foundation.Multisite.Templates.Site.ID));
db.Add(new DbTemplate(Templates.LanguageSettings.ID) {Fields = { { Templates.LanguageSettings.Fields.SupportedLanguages, languageItem.ID.ToString()} }});
db.Add(template);
var rootItem = new DbItem(rootName, rootId, template.ID){ new DbField(Templates.LanguageSettings.Fields.SupportedLanguages) { {"en", languageItem.ID.ToString()} } };
rootItem.Add(item);
db.Add(rootItem);
var contextItem = db.GetItem(item.ID);
Sitecore.Context.Item = contextItem;
var supportedLanguages = LanguageRepository.GetSupportedLanguages();
supportedLanguages.Count().Should().BeGreaterThan(0);
}
public void Init()
{
ssa = new SuperSimpleAuth ("testing_mtgdb.info",
"ae132e62-570f-4ffb-87cc-b9c087b09dfb");
mtgdb = new Db("http://127.0.0.1:8082");
repository = new MongoRepository ("mongodb://localhost", mtgdb, ssa);
admin = new Admin("http://127.0.0.1:8082");
//Super simple auth can't delete from here.
try
{
repository.AddPlaneswalker ("mtgdb_tester",
"test123", "*****@*****.**");
}
catch(Exception e)
{
System.Console.WriteLine (e.Message);
}
User ssaUser = ssa.Authenticate ("mtgdb_tester",
"test123", "127.0.0.1");
mtgdbUser = new Planeswalker
{
UserName = ssaUser.UserName,
AuthToken = ssaUser.AuthToken,
Email = ssaUser.Email,
Id = ssaUser.Id,
Claims = ssaUser.Claims,
Roles = ssaUser.Roles,
Profile = repository.GetProfile (ssaUser.Id)
};
}
public static void Main(string[] args)
{
var db = new Db();
if (!db.Hotels.Any())
{
InitData(db);
}
while (true)
{
Console.WriteLine("请输入半径：");
var limit = Console.ReadLine();
var intLimit = 0;
TryParse(limit, out intLimit);
Console.WriteLine("请输入坐标：xxx,xxx");
var locs = Console.ReadLine();
var locsSps = locs?.Split(',');
if (locsSps?.Length != 2)
{
continue;
}
var point = DbGeography.PointFromText($"Point({locsSps[0]} {locsSps[1]})", 4326);
var query = db.Hotels.Where(_ => _.Geo.Distance(point) < intLimit).ToList();
Console.WriteLine("符合条件的有：");
foreach (var hotel in query)
{
Console.WriteLine($"Name：{hotel.Name},Point:{hotel.Geo.Longitude},{hotel.Geo.Latitude}");
}
}
}
public void LoadProfiles_SettingWithProfiles_ShouldReturnExistentProfilesEnumerable(Db db, CurrentInteraction currentInteraction, ITracker tracker, Analytics.Tracking.Profile profile)
{
var profileItem = new DbItem("profile", ID.NewID, new TemplateID(ProfileItem.TemplateID));
db.Add(profileItem);
var profileSettingItem = new DbItem("profileSetting", ID.NewID, new TemplateID(Templates.ProfilingSettings.ID))
{
{Templates.ProfilingSettings.Fields.SiteProfiles, profileItem.ID.ToString()}
};
db.Add(profileSettingItem);
var provider = new ProfileProvider();
var fakeSiteContext = new FakeSiteContext(new StringDictionary
{
{"rootPath", "/sitecore"},
{"startItem", profileSettingItem.FullPath.Remove(0, "/sitecore".Length)}
})
{
Database = db.Database
};
using (new SiteContextSwitcher(fakeSiteContext))
{
var siteProfiles = provider.GetSiteProfiles();
siteProfiles.Count().Should().Be(1);
}
}
public void ShouldCreateTemplateFieldItemBasedOnDbField(ID templateId, DbField field)
{
using (var db = new Db { new DbTemplate(templateId) { field } })
{
db.GetItem(field.ID).Should().NotBeNull();
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Db db = new Db();
GridView1.DataSource = db.Fetch(string.Format("select * from emp where job = '{0}'", DropDownList1.SelectedValue));
GridView1.DataBind();
lblCnt.Text = GridView1.Rows.Count.ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
Db obj = new Db();
// string designation = obj.Fetchdesig(Txtuser.Text, Txtpwd.Text);
DataTable tab = obj.FetchEmployeeDetails(Txtuser.Text, Txtpwd.Text);
if (tab.Rows.Count > 0)
{
//try
//{
Session["EmployeeId"] = tab.Rows[0][0].ToString();
Session["EmployeeName"] = tab.Rows[0][1].ToString();
string designation = tab.Rows[0][2].ToString();
// string employeeid = obj.FetchEmployeeId(Txtuser.Text, Txtpwd.Text);
// Session["EmployeeId"] = employeeid;
if (designation == "Manager")
{
Response.Redirect("ManagerHomePage.aspx");
}
else if (designation == "Developer")
{
Response.Redirect("DeveloperHomePage.aspx");
}
else
{
Response.Redirect("TesterHomePage.aspx");
}
}
else
{
//Response.Write("Login Failed, try again");
msg.InnerText= "login failed try again";
}
}
public Parameters([NotNull] HttpContext c, [NotNull] Db db)
{
_c = c;
_db = db;
Set();
}
public State(string projectToken, string target, Logger logger, string workingDirectory)
{
this.projectToken = projectToken;
this.target = (target != null) ? target : Constants.DEFAULT_TARGET;
this.logger = (logger != null) ? logger : new NullLogger();
db = new Db(this.logger, workingDirectory);
}
public void MapToProperty_ItemIdAsGuid_ReturnsIdAsGuid()
{
//Assign
string targetPath = "/sitecore/content/target";
using (Db database = new Db
{
new Sitecore.FakeDb.DbItem("Target")
})
{
var mapper = new SitecoreIdMapper();
var config = new SitecoreIdConfiguration();
var property = typeof(Stub).GetProperty("GuidId");
var item = database.GetItem("/sitecore/content/target");
Assert.IsNotNull(item, "Item is null, check in Sitecore that item exists");
config.PropertyInfo = property;
mapper.Setup(new DataMapperResolverArgs(null, config));
var dataContext = new SitecoreDataMappingContext(null, item, null);
var expected = item.ID.Guid;
//Act
var value = mapper.MapToProperty(dataContext);
//Assert
Assert.AreEqual(expected, value);
}
}
public void GetDatasources_LocationSetByRelativeQuery_ShouldReturnSourcesFromSettingItem([Frozen]ISiteSettingsProvider siteSettingsProvider, [Greedy]DatasourceProvider provider, string name, string contextItemName, Db db, string settingItemName, Item item, string sourceRootName)
{
var contextItemId = ID.NewID;
var contextDbItem = new DbItem(contextItemName.Replace("-", String.Empty), contextItemId);
var rootName = sourceRootName.Replace("-", string.Empty);
var sourceRoot = new DbItem(rootName);
contextDbItem.Add(sourceRoot);
db.Add(contextDbItem);
var settingId = ID.NewID;
var settingDbItem = new DbItem(settingItemName.Replace("-", String.Empty), settingId, Templates.DatasourceConfiguration.ID)
{
new DbField(Templates.DatasourceConfiguration.Fields.DatasourceLocation)
{
{
"en", $"query:./{rootName}"
}
}
};
var contextItem = db.GetItem(contextItemId);
db.Add(settingDbItem);
var sourceRootItem = db.GetItem(sourceRoot.ID);
var settingItem = db.GetItem(settingId);
siteSettingsProvider.GetSetting(Arg.Any<Item>(), Arg.Any<string>(), Arg.Any<string>()).Returns(settingItem);
var sources = provider.GetDatasourceLocations(contextItem, name);
sources.Should().NotBeNull();
sources.Should().Contain(sourceRootItem);
}
public void CustomDataMapper()
{
//Arrange
var templateId = ID.NewID;
using (Db database = new Db
{
new Sitecore.FakeDb.DbItem("Target", ID.NewID, templateId)
{
new Sitecore.FakeDb.DbItem("Child1")
}
})
{
var resolver = Utilities.CreateStandardResolver();
resolver.DataMapperFactory.Insert(0, () => new StubDataMapper());
var context = Context.Create(resolver);
var service = new SitecoreService(database.Database, context);
//Act
var result = service.GetItem<Stub>("/sitecore");
//Assert
Assert.AreEqual("property test", result.Property1.Value);
}
}
public UserProfile GetUserProfile(string userName)
{
using (var db = new Db())
{
return db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == userName.ToLower());
}
}
public void ShouldDeepCopyItem()
{
// arrange
using (var db = new Db
{
new DbItem("original") { new DbItem("child") { { "Title", "Child" } } }
})
{
var original = db.GetItem("/sitecore/content/original");
var root = db.GetItem("/sitecore/content");
// act
var copy = original.CopyTo(root, "copy"); // deep is the default
// assert
copy.Should().NotBeNull();
copy.Children.Should().HaveCount(1);
var child = copy.Children.First();
child.Fields["Title"].Should().NotBeNull("'child.Fields[\"Title\"]' should not be null");
child.Fields["Title"].Value.Should().Be("Child");
child.ParentID.Should().Be(copy.ID);
child.Name.Should().Be("child");
child.Paths.FullPath.Should().Be("/sitecore/content/copy/child");
}
}
private void OnStorageChanged(object data)
{
// inefficient - set the status of every symbol based on its presence
foreach (Tag tag in ArtifactsFilterTagList)
{
anim.SetSymbolVisiblity(tag.ToString(), false);
}
foreach (Tag tag in storage.GetAllTagsInStorage())
{
anim.SetSymbolVisiblity(tag.ToString(), true);
}
// determine appropriate decor amount
Attributes attributes = this.GetAttributes();
if (decorModifier.Count > 0)
{
foreach (AttributeModifier attr in decorModifier.Values)
{
attributes.Remove(attr);
}
decorModifier.Clear();
}
// probably need a hashmap from the tag of the artifact to the decor modifier and decor radius modifier for it so I can properly remove
// and add the components
foreach (GameObject go in storage.items)
{
if (go.GetComponent <DecorProvider>() != null)
{
float decorValue = go.GetComponent <PrimaryElement>().Units *Mathf.Max(Db.Get().BuildingAttributes.Decor.Lookup(go).GetTotalValue() * STORED_DECOR_MODIFIER, MINIMUM_DECOR_PER_ITEM);
string description = string.Format(STRINGS.BUILDINGS.PREFABS.ITEMPEDESTAL.DISPLAYED_ITEM_FMT, go.GetComponent <KPrefabID>().PrefabTag.ProperName());
Tag prefabTag = go.GetComponent <KPrefabID>().PrefabTag;
if (decorModifier.ContainsKey(prefabTag))
{
decorModifier[prefabTag].SetValue(decorModifier[prefabTag].Value + decorValue);
}
else
{
decorModifier[prefabTag] = new AttributeModifier(Db.Get().BuildingAttributes.Decor.Id, decorValue, description, false, false, true);
}
}
}
foreach (AttributeModifier attr in decorModifier.Values)
{
attributes.Add(attr);
}
}
public static UserIdentifierCollection Where(Func <UserIdentifierColumns, QueryFilter <UserIdentifierColumns> > where, OrderBy <UserIdentifierColumns> orderBy = null, Database database = null)
{
database = database ?? Db.For <UserIdentifier>();
return(new UserIdentifierCollection(database.GetQuery <UserIdentifierColumns, UserIdentifier>(where, orderBy), true));
}
public void PlaceOrder()
{
// Get cart list
List <CartVM> cart = Session["cart"] as List <CartVM>;
// Get username
string username = User.Identity.Name;
int orderId = 0;
using (Db db = new Db())
{
// Init OrderDTO
OrderDTO orderDTO = new OrderDTO();
// Get user id
var query = db.Users.FirstOrDefault(x => x.Username == username);
int userId = query.Id;
// Add to OrderDTO and save
orderDTO.UserId = userId;
orderDTO.CreatedAt = DateTime.Now;
db.Orders.Add(orderDTO);
db.SaveChanges();
// Get inserted id
orderId = orderDTO.OrderId;
// Init OrderDetailsDTO
OrderDetailsDTO orderDetailsDTO = new OrderDetailsDTO();
// Add to OrderDetailsDTO
foreach (var item in cart)
{
orderDetailsDTO.OrderId = orderId;
orderDetailsDTO.UserId = userId;
orderDetailsDTO.ProductId = item.ProductId;
orderDetailsDTO.Quantity = item.Quantity;
db.OrderDetails.Add(orderDetailsDTO);
db.SaveChanges();
}
}
/*
* --> When user clicks checkout, admin will receive information about the order.
* --> Order will be stored in tblOrders
*/
// Email admin
//var client = new SmtpClient("smtp.mailtrap.io", 2525)
//{
// Credentials = new NetworkCredential("0d4dbda10c6f6e", "a37f5fbb161ccc"),
// EnableSsl = true
//};
//client.Send("*****@*****.**", "*****@*****.**", "New Order", "New Order! Order number " + orderId);
// Reset session
Session["cart"] = null;
}
protected void save_Click(object sender, EventArgs e)
{
if (valid())
{
DateTime Tgl = Convert.ToDateTime(tgl.Text);
string RRID = LibKom.RRID(Tgl.Month, Tgl.Year);
Db.Execute("EXEC spKomisiRewardRDaftar"
+ " '" + RRID + "'"
+ ",'" + Tgl + "'"
+ ",'" + Request.QueryString["id"] + "'"
+ ",'" + Cf.Str(ket.Text) + "'"
);
Db.Execute("UPDATE MS_KOMISI_REWARD_R SET "
+ " Project = '" + Project + "'"
+ " WHERE NoRR = '" + RRID + "'");
int index = 0;
foreach (Control tr in list.Controls)
{
CheckBox cb = (CheckBox)list.FindControl("cb_" + index);
if (cb.Checked)
{
DataTable dd = Db.Rs("SELECT * FROM MS_KOMISI_REWARD_P_DETAIL WHERE NoReward = '" + cb.Attributes["title"] + "'");
if (dd != null)
{
Db.Execute("EXEC spKomisiRewardRDetil"
+ " '" + RRID + "'"
+ ",'" + dd.Rows[0]["NoReward"].ToString() + "'"
+ ",'" + dd.Rows[0]["Reward"].ToString() + "'"
);
}
}
index++;
}
DataTable rsHeader = Db.Rs("SELECT "
+ " NoRR"
+ ",CONVERT(varchar,Tgl,106) AS [Tgl. Realisasi]"
+ ",Ket AS [Keterangan]"
+ ",NoRP AS [Kode Pengajuan]"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISI_REWARD_R "
+ " WHERE NoRR = '" + RRID + "'");
DataTable rsDetail = Db.Rs("SELECT "
+ " CONVERT(VARCHAR, SN) "
+ " + '. ' + NoReward"
+ " + ' ' + Reward "
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KOMISI_REWARD_R_DETAIL a WHERE NoRR = '" + RRID + "'");
string Ket = Cf.LogCapture(rsHeader)
+ Cf.LogList(rsDetail, "DETAIL");
Db.Execute("EXEC spLogKomisiRewardR"
+ " 'DAFTAR'"
+ ",'" + Act.UserID + "'"
+ ",'" + Act.IP + "'"
+ ",'" + Ket + "'"
+ ",'" + RRID + "'"
);
decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KOMISI_REWARD_R_LOG ORDER BY LogID DESC");
Db.Execute("UPDATE MS_KOMISI_REWARD_R_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID);
Response.Redirect("RewardRRegis1.aspx?id=" + RRID);
}
}
public Task <bool> UpdateAccountStatus(Guid id, AccountStatus status, IUnitOfWork uow = null)
{
return(Db.Find(m => m.Id == id).UseUow(uow).UpdateAsync(m => new AccountEntity {
Status = status
}));
}
public Task <AccountEntity> GetByPhone(string phone, AccountType type, Guid?tenantId)
{
return(Db.Find(m => m.Phone.Equals(phone) && m.Type == type && m.TenantId == tenantId).NotFilterTenant().FirstAsync());
}
public Task <AccountEntity> GetByEmail(string email, AccountType type, Guid?tenantId)
{
return(Db.Find(m => m.Email.Equals(email) && m.Type == type && m.TenantId == tenantId).NotFilterTenant().FirstAsync());
}
public Task <AccountEntity> GetByUserName(string userName, AccountType type, Guid?tenantId)
{
return(Db.Find(m => m.UserName.Equals(userName) && m.Type == type && m.TenantId == tenantId).NotFilterTenant().FirstAsync());
}
public Task <bool> UpdatePassword(Guid id, string password)
{
return(Db.Find(m => m.Id == id).UpdateAsync(m => new AccountEntity {
Password = password
}));
}
protected void Fill()
{
kode.Text = Request.QueryString["id"];
tgl.Text = Cf.Day(DateTime.Today);
list.Controls.Clear();
string strSql = "SELECT a.Reward, a.NoReward, b.*"
+ " FROM MS_KOMISI_REWARD_P_DETAIL a"
+ " INNER JOIN MS_KOMISI_REWARD b ON a.NoReward = b.NoReward"
+ " WHERE 1=1 "
+ " AND (SELECT COUNT(*) FROM MS_KOMISI_REWARD_R_DETAIL WHERE NoReward = a.NoReward) = 0"
+ " AND Project = '" + Project + "'"
+ " AND NoRP = '" + Request.QueryString["id"] + "'";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(list, rs, "Tidak terdapat data dengan kriteria seperti tersebut diatas.");
int index = 0;
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
HtmlTableRow r = new HtmlTableRow();
HtmlTableCell c;
CheckBox cb;
cb = new CheckBox();
cb.ID = "cb_" + index;
cb.Attributes["title"] = rs.Rows[i]["NoReward"].ToString();
c = new HtmlTableCell();
c.Controls.Add(cb);
r.Cells.Add(c);
c = new HtmlTableCell();
c.InnerHtml = rs.Rows[i]["NamaAgent"].ToString();
r.Cells.Add(c);
c = new HtmlTableCell();
c.InnerHtml = rs.Rows[i]["NoSkema"] + " (" + rs.Rows[i]["NamaSkema"] + ")";
r.Cells.Add(c);
c = new HtmlTableCell();
c.InnerHtml = Cf.Day(Convert.ToDateTime(rs.Rows[i]["PeriodeDari"])) + " s/d " + Cf.Day(Convert.ToDateTime(rs.Rows[i]["PeriodeSampai"]));
r.Cells.Add(c);
c = new HtmlTableCell();
c.InnerHtml = rs.Rows[i]["Reward"].ToString();
r.Cells.Add(c);
list.Controls.Add(r);
index++;
}
}
public PermissionsController(Db context)
{
_context = context;
}
private const int ARTIFACT_RADIUS = 5; // all artifacts have radius forced to 5
protected override void OnPrefabInit()
{
filteredStorage = new UncategorizedFilteredStorage(this, null, null, this, true,
Db.Get().ChoreTypes.StorageFetch);
}
public void Delete(int id)
{
Db.DeleteById <InvoiceElement>(id);
}
private void Fill()
{
string strSql = "SELECT"
+ " LogID"
+ ",Tgl"
+ ",Aktivitas"
+ ",UserID"
+ ",IP"
+ ",(SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..USERNAME WHERE UserID = " + tb.SelectedValue + ".UserID) AS Nama"
+ ",Pk"
+ ",Approve"
+ " FROM " + tb.SelectedValue
+ " WHERE Pk = '" + Pk + "' ORDER BY LogID";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Log file tidak tersedia.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["Tgl"]);
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Time(rs.Rows[i]["Tgl"]);
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["UserID"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Nama"].ToString();
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = "<a href=\"javascript:popLog('" + rs.Rows[i]["LogID"] + "','" + tb.SelectedValue + "','" + tb.SelectedItem.Text + "','" + Pk + "')\">"
+ rs.Rows[i]["Aktivitas"].ToString()
+ "</a>";
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Pk"].ToString();
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Approve"].ToString();
c.Wrap = false;
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
private void termin(string Nokontrak)
{
TableRow r2 = new TableRow();
TableRow r3 = new TableRow();
TableRow r4 = new TableRow();
TableCell c2 = new TableCell();
TableCell c3 = new TableCell();
TableCell c4 = new TableCell();
System.Text.StringBuilder ArrTermin = new System.Text.StringBuilder();
int term = Db.SingleInteger("select count(distinct termin) from ms_komisi_detail where Nokontrak ='" + Nokontrak + "'");
DataTable rj = Db.Rs("Select * from ms_komisi_detail where nokontrak ='" + Nokontrak + "' And Baris = 1");
DataTable rj2 = Db.Rs("Select * from ms_komisi_detail where nokontrak ='" + Nokontrak + "' And Baris = 2");
if (term == 1)
{
c2 = new TableCell();
c2.Text = "TERMIN 1";
r2.Cells.Add(c2);
for (int g = 0; g < rj.Rows.Count; g++)
{
c2 = new TableCell();
c2.Text = Cf.Num(rj.Rows[g]["NilaiKomisi"]);
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj.Rows[g]["NilaiBayar"])));
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Day(rj.Rows[g]["TglBayar"]);
r2.Cells.Add(c2);
}
for (int h = 0; h < rj.Rows.Count; h++)
{
c2 = new TableCell();
c2.Text = Cf.Num(rj.Rows[h]["ClosingFee"]);
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj.Rows[h]["NilaiBayarCF"])));
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Day(rj.Rows[h]["TglBayarClosingfee"]);
r2.Cells.Add(c2);
}
}
else if (term == 2)
{
c2 = new TableCell();
c2.Text = "TERMIN 1";
r2.Cells.Add(c2);
c3 = new TableCell();
c3.Text = "TERMIN 2";
r3.Cells.Add(c3);
for (int f = 0; f < rj.Rows.Count; f++)
{
c2 = new TableCell();
c2.Text = Cf.Num(rj.Rows[f]["NilaiKomisi"]);
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj.Rows[f]["NilaiBayar"])));
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Day(rj.Rows[f]["TglBayar"]);
r2.Cells.Add(c2);
}
//closingfee
for (int h = 0; h < rj.Rows.Count; h++)
{
c2 = new TableCell();
c2.Text = Cf.Num(rj.Rows[h]["ClosingFee"]);
c2.RowSpan = 2;
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj.Rows[h]["NilaiBayarCF"])));
c2.RowSpan = 2;
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Day(rj.Rows[h]["TglBayarClosingfee"]);
c2.RowSpan = 2;
r2.Cells.Add(c2);
}
for (int f2 = 0; f2 < rj2.Rows.Count; f2++)
{
c3 = new TableCell();
c3.Text = Cf.Num(rj2.Rows[f2]["NilaiKomisi"]);
r3.Cells.Add(c3);
c3 = new TableCell();
c3.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj2.Rows[f2]["NilaiBayar"])));
r3.Cells.Add(c3);
c3 = new TableCell();
c3.Text = Cf.Day(rj2.Rows[f2]["TglBayar"]);
r3.Cells.Add(c3);
}
}
else if (term == 3)
{
DataTable rj3 = Db.Rs("Select * from ms_komisi_detail where nokontrak ='" + Nokontrak + "' And Baris = 3");
c2 = new TableCell();
c2.Text = "TERMIN 1";
r2.Cells.Add(c2);
c3 = new TableCell();
c3.Text = "TERMIN 2";
r3.Cells.Add(c3);
c4 = new TableCell();
c4.Text = "TERMIN 3";
r4.Cells.Add(c4);
for (int j = 0; j < rj.Rows.Count; j++)
{
c2 = new TableCell();
c2.Text = Cf.Num(rj.Rows[j]["NilaiKomisi"]);
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj.Rows[j]["NilaiBayar"])));
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Day(rj.Rows[j]["TglBayar"]);
r2.Cells.Add(c2);
}
//closingfee
for (int h = 0; h < rj.Rows.Count; h++)
{
c2 = new TableCell();
c2.Text = Cf.Num(rj.Rows[h]["ClosingFee"]);
c2.RowSpan = 3;
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj.Rows[h]["NilaiBayarCF"])));
c2.RowSpan = 3;
r2.Cells.Add(c2);
c2 = new TableCell();
c2.Text = Cf.Day(rj.Rows[h]["TglBayarClosingfee"]);
c2.RowSpan = 3;
r2.Cells.Add(c2);
}
for (int j2 = 0; j2 < rj2.Rows.Count; j2++)
{
c3 = new TableCell();
c3.Text = Cf.Num(rj2.Rows[j2]["NilaiKomisi"]);
r3.Cells.Add(c3);
c3 = new TableCell();
c3.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj2.Rows[j2]["NilaiBayar"])));
r3.Cells.Add(c3);
c3 = new TableCell();
c3.Text = Cf.Day(rj2.Rows[j2]["TglBayar"]);
r3.Cells.Add(c3);
}
for (int j3 = 0; j3 < rj3.Rows.Count; j3++)
{
c4 = new TableCell();
c4.Text = Cf.Num(rj3.Rows[j3]["NilaiKomisi"]);
r4.Cells.Add(c4);
c4 = new TableCell();
c4.Text = Cf.Num(Math.Round(Convert.ToDecimal(rj3.Rows[j3]["NilaiBayar"])));
r4.Cells.Add(c4);
c4 = new TableCell();
c4.Text = Cf.Day(rj3.Rows[j3]["TglBayar"]);
r4.Cells.Add(c4);
}
}
rpt.Rows.Add(r2);
rpt.Rows.Add(r3);
rpt.Rows.Add(r4);
}
public static ObjectDescriptorCollection Where(Func <ObjectDescriptorColumns, QueryFilter <ObjectDescriptorColumns> > where, OrderBy <ObjectDescriptorColumns> orderBy = null, Database database = null)
{
database = database ?? Db.For <ObjectDescriptor>();
return(new ObjectDescriptorCollection(database.GetQuery <ObjectDescriptorColumns, ObjectDescriptor>(where, orderBy), true));
}
protected void pdf_Click(object sender, System.EventArgs e)
{
Process p = new System.Diagnostics.Process();
string Nama = "Laporan Master Komisi Detail";
string Link = "";
DateTime TglGenerate = DateTime.Now;
string FileName = "";
string FileType = "application/pdf";
string UserID = Act.UserID;
string IP = Act.IP;
Db.Execute("EXEC spLapPDFDaftar"
+ " '" + Nama + "'"
+ ",'" + Link + "'"
+ ",'" + TglGenerate + "'"
+ ",'" + IP + "'"
+ ",'" + UserID + "'"
+ ",'" + FileName + "'"
+ ",'" + FileType + "'"
+ ",'" + Convert.ToDateTime(dari.Text) + "'"
+ ",'" + Convert.ToDateTime(sampai.Text) + "'"
);
//get nomor customer terbaru
int NoAttachment = Db.SingleInteger(
"SELECT TOP 1 AttachmentID FROM LapPDF ORDER BY AttachmentID DESC");
string strSql = "SELECT * FROM ISC064_MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + NoAttachment + "'";
DataTable rs = Db.Rs(strSql);
string nfilename = "MasterKomisiDetail" + NoAttachment + ".pdf";
//update filename
Db.Execute("UPDATE ISC064_MARKETINGJUAL..LapPDF SET FileName= '" + nfilename + "' WHERE AttachmentID = " + NoAttachment);
//folder untuk menyimpan file pdf
string save = Mi.PathFilePDFReport + "MasterKomisiDetail" + rs.Rows[0]["AttachmentID"] + ".pdf";
//declare parameter
//string Sales = agent.SelectedValue;
string nStatusS = "";
string nStatusA = "";
string nStatusB = "";
if (statusS.Checked == true)
{
nStatusS = statusS.Text;
}
else
{
nStatusS = "";
}
if (statusA.Checked == true)
{
nStatusA = statusA.Text;
}
else
{
nStatusA = "";
}
if (statusB.Checked == true)
{
nStatusB = statusB.Text;
}
else
{
nStatusB = "";
}
//link untuk download pdf
string link = Mi.PathAlamatWeb + "komisi/LaporanPDF/PDFMasterKomisiDetail.aspx?id=" + rs.Rows[0]["AttachmentID"]
+ "&status_s=" + nStatusS
+ "&status_b=" + nStatusB
+ "&status_a=" + nStatusA
+ "&userid=" + UserID
+ "&project=" + project.SelectedValue
+ "&pers=" + pers.SelectedValue
;
//update link
Db.Execute("UPDATE ISC064_MARKETINGJUAL..LapPDF SET Link= '" + link + "' WHERE AttachmentID = " + NoAttachment);
//format page
p.StartInfo.Arguments = "--orientation landscape --page-width 8.5in --page-height 11in --margin-left 0 --margin-right 0 --margin-top 0.25cm --margin-bottom 0 " + link + " " + save;
//panggil aplikasi untuk mengconvert pdf
p.StartInfo.FileName = Mi.PathWkhtmlPDFReport;
p.Start();
//60000 -> waktu jeda lama convert pdf
p.WaitForExit(30000);
string Src = Mi.PathFilePDFReport + nfilename;
Mi.DownloadPDF(this, Src, (rs.Rows[0]["FileName"]).ToString(), rs.Rows[0]["FileType"].ToString());
}
public static void Insert()
{
var db = Db;
db.CodeFirst.InitTables <UinitBlukTable>();
db.DbMaintenance.TruncateTable <UinitBlukTable>();
db.Insertable(new List <UinitBlukTable>
{
new UinitBlukTable()
{
Id = 1, Create = DateTime.Now, Name = "00"
},
new UinitBlukTable()
{
Id = 2, Create = DateTime.Now, Name = "11"
}
}).UseSqlServer().ExecuteBlueCopy();
var dt = db.Queryable <UinitBlukTable>().ToDataTable();
dt.Rows[0][0] = 3;
dt.Rows[1][0] = 4;
dt.TableName = "[UinitBlukTable]";
db.Insertable(dt).UseSqlServer().ExecuteBlueCopy();
db.Insertable(new List <UinitBlukTable2>
{
new UinitBlukTable2()
{
Id = 5, Name = "55"
},
new UinitBlukTable2()
{
Id = 6, Name = "66"
}
}).UseSqlServer().ExecuteBlueCopy();
db.Ado.BeginTran();
db.Insertable(new List <UinitBlukTable2>
{
new UinitBlukTable2()
{
Id = 7, Name = "77"
},
new UinitBlukTable2()
{
Id = 8, Name = "88"
}
}).UseSqlServer().ExecuteBlueCopy();
var task = db.Insertable(new List <UinitBlukTable2>
{
new UinitBlukTable2()
{
Id = 9, Name = "9"
},
new UinitBlukTable2()
{
Id = 10, Name = "10"
}
}).UseSqlServer().ExecuteBlueCopyAsync();
task.Wait();
db.Ado.CommitTran();
var list = db.Queryable <UinitBlukTable>().ToList();
db.DbMaintenance.TruncateTable <UinitBlukTable>();
if (string.Join("", list.Select(it => it.Id)) != "12345678910")
{
throw new Exception("Unit Insert");
}
List <UinitBlukTable> list2 = new List <UinitBlukTable>();
for (int i = 1; i <= 20; i++)
{
UinitBlukTable data = new UinitBlukTable()
{
Create = DateTime.Now.AddDays(-1),
Id = i,
Name = i % 3 == 0?"a":"b"
};
list2.Add(data);
}
list2.First().Name = null;
db.DbMaintenance.TruncateTable <UinitBlukTable>();
db.Insertable(new UinitBlukTable()
{
Id = 2, Name = "b", Create = DateTime.Now
}).ExecuteCommand();
var x = Db.Storageable(list2)
.SplitInsert(it => it.NotAny())
.SplitUpdate(it => it.Any())
.SplitDelete(it => it.Item.Id > 10)
.SplitIgnore(it => it.Item.Id == 1)
.SplitError(it => it.Item.Id == 3, "id不能等于3")
.SplitError(it => it.Item.Id == 4, "id不能等于4")
.SplitError(it => it.Item.Id == 5, "id不能等于5")
.SplitError(it => it.Item.Name == null, "name不能等于")
.WhereColumns(it => new { it.Id })
.ToStorage();
x.AsDeleteable.ExecuteCommand();
x.AsInsertable.ExecuteCommand();
x.AsUpdateable.ExecuteCommand();
foreach (var item in x.ErrorList)
{
Console.Write(item.StorageMessage + " ");
}
db.DbMaintenance.TruncateTable <UinitBlukTable>();
IDemo1();
IDemo2();
IDemo3();
IDemo4();
IDemo5();
IDemo6();
}
public List <MutualEntity> GetMutuals()
{
const string procedures = @"uspGet_All_Mutual";
return(Db.ReadList(procedures, true, Make));
}
private void Fill()
{
string Status = "";
if (statusA.Checked)
{
Status = " AND A.Status = 'A'";
}
if (statusB.Checked)
{
Status = " AND A.Status = 'B'";
}
string tgl = "";
string order = "";
if (tglkontrak.Checked)
{
tgl = "A.TglKontrak";
order = ",A.NoKontrak";
}
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
if (Dari > Sampai)
{
DateTime x = Sampai;
Sampai = Dari;
Dari = x;
}
//string Agent = "", Agent2 = "";
//if (agent.SelectedIndex != 0)
//{
// Agent = " AND B.NoAgent = '" + agent.SelectedValue + "'";
// Agent2 = " AND A.NoAgent = '" + agent.SelectedValue + "'";
//}
//else
//{
// if (UserAgent() > 0)
// Agent = " AND B.NoAgent = " + UserAgent();
//}
string Project = "";
if (project.SelectedValue != "SEMUA")
{
Project = " AND A.Project = '" + project.SelectedValue + "'";
}
string Perusahaan = "";
if (pers.SelectedValue != "SEMUA")
{
Perusahaan = " AND A.Pers = '" + pers.SelectedValue + "'";
}
int index = 1;
int no = 1;
decimal t1 = 0;
//string sql = "SELECT DISTINCT (NoAgent) from MS_KONTRAK A"
// + " where (select ISNULL(count(*),0) from MS_KOMISI where NoKontrak = A.NoKontrak) > 0" +Project + Perusahaan;
//DataTable sr = Db.Rs(sql);
//decimal t1 = 0, t2 = 0;
//for (int g = 0; g < sr.Rows.Count; g++)
//{
//if (!Response.IsClientConnected) break;
//string strSql = "SELECT "
// + "A.NoKontrak"
// + ",A.TglKontrak"
// + ",A.NilaiDPP"
// + ",A.NoUnit"
// + ",A.Skema"
// + ",A.NilaiKontrak"
// + ",B.Nama AS Ag"
// + ",B.Principal"
// + ",B.NPWP"
// + ",B.Rekening"
// + ",A.Status"
// + ",A.PersenLunas"
// + ",C.Nama as Customer"
// + ",A.NoAgent"
// + ",A.NoStock"
// + " FROM MS_KONTRAK A INNER JOIN MS_AGENT B ON A.NoAgent = B.NoAgent"
// + " INNER JOIN MS_CUSTOMER C ON A.NoCustomer = C.NoCustomer"
// + " WHERE A.NoAgent= '" + sr.Rows[g]["NoAgent"] + "'"
// + " AND A.FlagKomisi = '1'"
// + Status
// + " AND CONVERT(varchar,A.TglKontrak,112) >= '" + Cf.Tgl112(Dari) + "'"
// + " AND CONVERT(varchar,A.TglKontrak,112) <= '" + Cf.Tgl112(Sampai) + "'"
// //+ Agent
// + Project
// + Perusahaan
// + " ORDER BY B.Nama"
// + order;
string strSql = "SELECT b.*,d.* "
+ ",A.NoKontrak"
+ ",A.NoUnit"
+ ",C.Nilai"
+ ",B.NamaAgent"
+ ",A.Status"
+ ",A.PersenLunas"
//+ ",C.Nama as Customer"
+ ",A.NoAgent"
+ " FROM MS_KONTRAK A INNER JOIN MS_KOMISI B ON A.NoKontrak = B.NoKontrak"
+ " INNER JOIN MS_KOMISI_DETAIL C ON B.NoKomisi = C.NoKomisi"
+ " INNER JOIN MS_KOMISI_TERM D ON C.NoKomisi = D.NoKomisi"
//+ " WHERE A.NoAgent= '" + sr.Rows[g]["NoAgent"] + "'"
//+ " AND A.FlagKomisi = '1'"
+ Status
+ " AND CONVERT(varchar,A.TglKontrak,112) >= '" + Cf.Tgl112(Dari) + "'"
+ " AND CONVERT(varchar,A.TglKontrak,112) <= '" + Cf.Tgl112(Sampai) + "'"
//+ Agent
+ Project
+ Perusahaan
+ " ORDER BY B.NamaAgent"
+ order;
DataTable rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
TableRow r2a;
TableHeaderCell th2;
Table tb;
r.VerticalAlign = VerticalAlign.Top;
//r.Attributes["ondblclick"] = "popJadwalKomisi('" + rs.Rows[i]["NoKontrak"] + "')";
//nambah no default
//c = new TableCell();
//c.Text = (no).ToString();
////c.RowSpan = 4;
//c.HorizontalAlign = HorizontalAlign.Left;
//r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoKontrak"].ToString();
string NoKontrak = rs.Rows[i]["NoKontrak"].ToString();
//c.RowSpan = 4;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoUnit"].ToString();
//c.RowSpan = 4;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NamaAgent"].ToString();
//c.RowSpan = 4;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NamaTermin"].ToString();
//c.RowSpan = 4;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
//c.Text = Cf.Num(Convert.ToDecimal(rs.Rows[i]["Nilai"]));
decimal NKom = (Convert.ToDecimal(rs.Rows[i]["Nilai"])); //Db.SingleDecimal("Select Nilai From MS_KOMISI_DETAIL Where NoKontrak ='" + rs.Rows[i]["NoKontrak"].ToString() + "'");
c.Text = Cf.Num(Math.Round(NKom));
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
//cek syarat cair=================================================================
string bf = "SELECT ISNULL(SUM(NilaiTagihan),0) FROM MS_TAGIHAN WHERE NoKontrak = '" + rs.Rows[i]["NoKontrak"].ToString() + "' AND Tipe = 'BF'";
decimal NilaiBF = Db.SingleDecimal(bf);
string bbf = "SELECT ISNULL(SUM(NilaiPelunasan),0) FROM MS_PELUNASAN a INNER JOIN MS_TAGIHAN b ON a.NoKontrak = b.NoKontrak WHERE a.NoKontrak = '" + rs.Rows[i]["NoKontrak"].ToString() + "' AND a.NoTagihan = b.NoUrut AND b.Tipe = 'BF'";
decimal BayarBF = Db.SingleDecimal(bbf);
decimal PersenBF = NilaiBF != 0 ? BayarBF / NilaiBF * 100 : 0;
string dp = "SELECT ISNULL(SUM(NilaiTagihan),0) FROM MS_TAGIHAN WHERE NoKontrak = '" + rs.Rows[i]["NoKontrak"].ToString() + "' AND Tipe = 'DP'";
decimal NilaiDP = Db.SingleDecimal(dp);
string bdp = "SELECT ISNULL(SUM(NilaiPelunasan),0) FROM MS_PELUNASAN a INNER JOIN MS_TAGIHAN b ON a.NoKontrak = b.NoKontrak WHERE a.NoKontrak = '" + rs.Rows[i]["NoKontrak"].ToString() + "' AND a.NoTagihan = b.NoUrut AND b.Tipe = 'DP'";
decimal BayarDP = Db.SingleDecimal(bdp);
decimal PersenDP = NilaiDP != 0 ? BayarDP / NilaiDP * 100 : 0;
string ang = "SELECT ISNULL(SUM(NilaiTagihan),0) FROM MS_TAGIHAN WHERE NoKontrak = '" + rs.Rows[i]["NoKontrak"].ToString() + "' AND Tipe = 'ANG'";
decimal NilaiANG = Db.SingleDecimal(ang);
string bang = "SELECT ISNULL(SUM(NilaiPelunasan),0) FROM MS_PELUNASAN a INNER JOIN MS_TAGIHAN b ON a.NoKontrak = b.NoKontrak WHERE a.NoKontrak = '" + rs.Rows[i]["NoKontrak"].ToString() + "' AND a.NoTagihan = b.NoUrut AND b.Tipe = 'ANG'";
decimal BayarANG = Db.SingleDecimal(bang);
decimal PersenANG = NilaiANG != 0 ? BayarANG / NilaiANG * 100 : 0;
decimal PersenLunas = 0;
bool PPJB = false, AJB = false, AKAD = false;
string kon = "SELECT PersenLunas, PPJB, AJB, StatusAkad FROM MS_KONTRAK WHERE NoKontrak = '" + rs.Rows[i]["NoKontrak"].ToString() + "'";
DataTable rkon = Db.Rs(kon);
if (kon != null)
{
PersenLunas = Convert.ToDecimal(rkon.Rows[0]["PersenLunas"]);
PPJB = rkon.Rows[0]["PPJB"].ToString() != "B" ? true : false;
AJB = rkon.Rows[0]["AJB"].ToString() == "D" ? true : false;
AKAD = rkon.Rows[0]["StatusAkad"].ToString() == "SELESAI" ? true : false;
}
bool pengajuan = false;
bool Lunas = Convert.ToBoolean(rs.Rows[i]["Lunas"]);
bool BF = Convert.ToBoolean(rs.Rows[i]["BF"]);
bool DP = Convert.ToBoolean(rs.Rows[i]["DP"]);
bool ANG = Convert.ToBoolean(rs.Rows[i]["ANG"]);
bool PPJB_ = Convert.ToBoolean(rs.Rows[i]["PPJB"]);
bool AJB_ = Convert.ToBoolean(rs.Rows[i]["AJB"]);
bool AKAD_ = Convert.ToBoolean(rs.Rows[i]["AKAD"]);
int a = 0, b = 0;
if (!Lunas && !BF && !DP && !ANG && !PPJB_ && !AJB_ && !AKAD_)
{
pengajuan = true;
}
else
{
//Salah satu
if (Convert.ToInt32(rs.Rows[i]["TipeCair"]) == 1)
{
if ((Lunas && PersenLunas >= Convert.ToDecimal(rs.Rows[i]["PersenLunas"])) || (BF && PersenBF >= Convert.ToDecimal(rs.Rows[i]["PersenBF"])) || (DP && PersenDP >= Convert.ToDecimal(rs.Rows[i]["PersenDP"])) || (ANG && PersenANG >= Convert.ToDecimal(rs.Rows[i]["PersenANG"])) || (PPJB_ && PPJB) || (AJB_ && AJB) || (AKAD_ && AKAD))
{
pengajuan = true;
}
}
//Semua
else
{
if (Lunas)
{
a++;
if (PersenLunas >= Convert.ToDecimal(rs.Rows[i]["PersenLunas"]))
{
b++;
}
}
if (BF)
{
a++;
if (PersenBF >= Convert.ToDecimal(rs.Rows[i]["PersenBF"]))
{
b++;
}
}
if (DP)
{
a++;
if (PersenDP >= Convert.ToDecimal(rs.Rows[i]["PersenDP"]))
{
b++;
}
}
if (ANG)
{
a++;
if (PersenANG >= Convert.ToDecimal(rs.Rows[i]["PersenANG"]))
{
b++;
}
}
if (PPJB_)
{
a++;
if (PPJB)
{
b++;
}
}
if (AJB_)
{
a++;
if (AJB)
{
b++;
}
}
if (AKAD_)
{
a++;
if (AKAD)
{
b++;
}
}
if (a == b)
{
pengajuan = true;
}
}
}
//======================================================================================
string StatusKom = "<label style='color:red;'>Belum Bisa Pengajuan</label>", NoRef = "";
if (pengajuan)
{
StatusKom = "<label style='color:yellow;'>Siap Cair</label>";
}
DataTable kp = Db.Rs("SELECT * FROM MS_KOMISIP_DETAIL WHERE NoKomisi = '" + rs.Rows[i]["NoKomisi"].ToString() + "' AND SN_KomisiTermin = " + Convert.ToInt32(rs.Rows[i]["SN"]));
if (kp.Rows.Count > 0)
{
NoRef = kp.Rows[0]["NoKomisiP"].ToString();
StatusKom = "<label style='color:green;'>Pengajuan</label>";
DataTable kr = Db.Rs("SELECT * FROM MS_KOMISIR_DETAIL WHERE NoKomisi = '" + rs.Rows[i]["NoKomisi"].ToString() + "' AND SN_KomisiTermin = " + Convert.ToInt32(rs.Rows[i]["SN"]));
if (kr.Rows.Count > 0)
{
NoRef = kr.Rows[0]["NoKomisiR"].ToString();
StatusKom = "<label style='color:blue;'>Cair</label>";
}
}
c = new TableCell();
c.Text = StatusKom;
r.Cells.Add(c);
t1 = NKom;
rpt.Rows.Add(r);
no++;
SubTotal("SUB TOTAL", t1);
//termin(NoKontrak);
}
//}
//SubTotal("GRAND TOTAL", t1);
}
///<summary>Deletes one Sheet from the database.</summary>
public static void Delete(long sheetNum){
string command="DELETE FROM sheet "
+"WHERE SheetNum = "+POut.Long(sheetNum);
Db.NonQ(command);
}
public int InsertMutual(MutualEntity mutual)
{
const string sql = @"uspInsert_Mutual";
return(Db.Insert(sql, true, Take(mutual)));
}
//Update record
public static void Update(ProfileInfo o, string user)
{
var result = from r in Db.ProfileInfos where r.Id == o.Id select r;
Db.SaveChanges(user);
}
public string UpdateMutual(MutualEntity mutual)
{
const string sql = @"uspUpdate_Mutual";
return(Db.Update(sql, true, Take(mutual)));
}
private void InitTSBAndPlazaAndLanes()
{
if (null == Db)
{
return;
}
if (Db.Table <TSB>().Count() > 0)
{
return; // already exists.
}
TSB item;
PlazaGroup plazaGroup;
Plaza plaza;
Lane lane;
#region DIN DAENG
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "311";
item.TSBNameEN = "DIN DAENG";
item.TSBNameTH = "ดินแดง";
item.Active = true;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup DIN DAENG
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "DD",
PlazaGroupNameEN = "DIN DAENG",
PlazaGroupNameTH = "ดินแดง",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza DIN DAENG 1
plaza = new Plaza()
{
PlazaId = "3101",
PlazaNameEN = "DIN DAENG 1",
PlazaNameTH = "ดินแดง 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 1,
LaneId = "DD01",
LaneType = "MTC",
LaneAbbr = "DD01",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 2,
LaneId = "DD02",
LaneType = "MTC",
LaneAbbr = "DD02",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 3,
LaneId = "DD03",
LaneType = "A/M",
LaneAbbr = "DD03",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 4,
LaneId = "DD04",
LaneType = "ETC",
LaneAbbr = "DD04",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#region Plaza DIN DAENG 2
plaza = new Plaza()
{
PlazaId = "3102",
PlazaNameEN = "DIN DAENG 2",
PlazaNameTH = "ดินแดง 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 11,
LaneId = "DD11",
LaneType = "?",
LaneAbbr = "DD11",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 12,
LaneId = "DD12",
LaneType = "?",
LaneAbbr = "DD12",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 13,
LaneId = "DD13",
LaneType = "?",
LaneAbbr = "DD13",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 14,
LaneId = "DD14",
LaneType = "?",
LaneAbbr = "DD14",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 15,
LaneId = "DD15",
LaneType = "?",
LaneAbbr = "DD15",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 16,
LaneId = "DD16",
LaneType = "?",
LaneAbbr = "DD16",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#endregion
#endregion
#region SUTHISARN
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "312";
item.TSBNameEN = "SUTHISARN";
item.TSBNameTH = "สุทธิสาร";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup SUTHISARN
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "SS",
PlazaGroupNameEN = "SUTHISARN",
PlazaGroupNameTH = "สุทธิสาร",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza SUTHISARN
plaza = new Plaza()
{
PlazaId = "3103",
PlazaNameEN = "SUTHISARN",
PlazaNameTH = "สุทธิสาร",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 1,
LaneId = "SS01",
LaneType = "?",
LaneAbbr = "SS01",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 2,
LaneId = "SS02",
LaneType = "?",
LaneAbbr = "SS02",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 3,
LaneId = "SS03",
LaneType = "?",
LaneAbbr = "SS03",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#endregion
#endregion
#region LAD PRAO
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "313";
item.TSBNameEN = "LAD PRAO";
item.TSBNameTH = "ลาดพร้าว";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup LAD PRAO INBOUND
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "LP-IN",
PlazaGroupNameEN = "LAD PRAO INBOUND",
PlazaGroupNameTH = "ลาดพร้าว ขาเข้า",
Direction = "IN",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza LAD PRAO INBOUND
plaza = new Plaza()
{
PlazaId = "3104",
PlazaNameEN = "LAD PRAO INBOUND",
PlazaNameTH = "ลาดพร้าว ขาเข้า",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 1,
LaneId = "LP01",
LaneType = "?",
LaneAbbr = "LP01",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 2,
LaneId = "LP02",
LaneType = "?",
LaneAbbr = "LP02",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 3,
LaneId = "LP03",
LaneType = "?",
LaneAbbr = "LP03",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 4,
LaneId = "LP04",
LaneType = "?",
LaneAbbr = "LP04",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#endregion
#region PlazaGroup LAD PRAO OUTBOUND
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "LP-OUT",
PlazaGroupNameEN = "LAD PRAO OUTBOUND",
PlazaGroupNameTH = "ลาดพร้าว ขาออก",
Direction = "OUT",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza LAD PRAO OUTBOUND
plaza = new Plaza()
{
PlazaId = "3105",
PlazaNameEN = "LAD PRAO OUTBOUND",
PlazaNameTH = "ลาดพร้าว ขาออก",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes
lane = new Lane()
{
LaneNo = 21,
LaneId = "LP21",
LaneType = "?",
LaneAbbr = "LP21",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 22,
LaneId = "LP22",
LaneType = "?",
LaneAbbr = "LP22",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
lane = new Lane()
{
LaneNo = 23,
LaneId = "LP23",
LaneType = "?",
LaneAbbr = "LP23",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId,
PlazaId = plaza.PlazaId
};
if (!Lane.Exists(lane))
{
Lane.Save(lane);
}
#endregion
#endregion
#endregion
#endregion
#region RATCHADA PHISEK
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "314";
item.TSBNameEN = "RATCHADA PHISEK";
item.TSBNameTH = "รัชดาภิเษก";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup RATCHADA PHISEK
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "RP",
PlazaGroupNameEN = "RATCHADA PHISEK",
PlazaGroupNameTH = "รัชดาภิเษก",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza RATCHADA PHISEK 1
plaza = new Plaza()
{
PlazaId = "3106",
PlazaNameEN = "RATCHADA PHISEK 1",
PlazaNameTH = "รัชดาภิเษก 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#region Plaza RATCHADA PHISEK 2
plaza = new Plaza()
{
PlazaId = "3107",
PlazaNameEN = "RATCHADA PHISEK 2",
PlazaNameTH = "รัชดาภิเษก 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
#region BANGKHEN
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "315";
item.TSBNameEN = "BANGKHEN";
item.TSBNameTH = "บางเขน";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup BANGKHEN
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "BK",
PlazaGroupNameEN = "BANGKHEN",
PlazaGroupNameTH = "บางเขน",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza BANGKHEN
plaza = new Plaza()
{
PlazaId = "3108",
PlazaNameEN = "BANGKHEN",
PlazaNameTH = "บางเขน",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#endregion
#region Lanes (no data)
#endregion
#endregion
#endregion
#region CHANGEWATTANA
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "316";
item.TSBNameEN = "CHANGEWATTANA";
item.TSBNameTH = "แจ้งวัฒนะ";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup CHANGEWATTANA
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "CW",
PlazaGroupNameEN = "CHANGEWATTANA",
PlazaGroupNameTH = "แจ้งวัฒนะ",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza CHANGEWATTANA 1
plaza = new Plaza()
{
PlazaId = "3109",
PlazaNameEN = "CHANGEWATTANA 1",
PlazaNameTH = "แจ้งวัฒนะ 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#region Plaza CHANGEWATTANA 2
plaza = new Plaza()
{
PlazaId = "3110",
PlazaNameEN = "CHANGEWATTANA 2",
PlazaNameTH = "แจ้งวัฒนะ 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
#region LAKSI
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "317";
item.TSBNameEN = "LAKSI";
item.TSBNameTH = "หลักสี่";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup LAKSI INBOUND
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "LS-IN",
PlazaGroupNameEN = "LAKSI INBOUND",
PlazaGroupNameTH = "หลักสี่ ขาเข้า",
Direction = "IN",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza LAKSI INBOUND
plaza = new Plaza()
{
PlazaId = "3111",
PlazaNameEN = "LAKSI INBOUND",
PlazaNameTH = "หลักสี่ ขาเข้า",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#region PlazaGroup LAKSI OUTBOUND
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "LS-OUT",
PlazaGroupNameEN = "LAKSI OUTBOUND",
PlazaGroupNameTH = "หลักสี่ ขาออก",
Direction = "OUT",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza LAKSI OUTBOUND
plaza = new Plaza()
{
PlazaId = "3112",
PlazaNameEN = "LAKSI OUTBOUND",
PlazaNameTH = "หลักสี่ ขาออก",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
#region DON MUANG
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "318";
item.TSBNameEN = "DON MUANG";
item.TSBNameTH = "ดอนเมือง";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup DON MUANG
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "DM",
PlazaGroupNameEN = "DON MUANG",
PlazaGroupNameTH = "ดอนเมือง",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza DON MUANG 1
plaza = new Plaza()
{
PlazaId = "3113",
PlazaNameEN = "DON MUANG 1",
PlazaNameTH = "ดอนเมือง 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#region Plaza DON MUANG 2
plaza = new Plaza()
{
PlazaId = "3114",
PlazaNameEN = "DON MUANG 2",
PlazaNameTH = "ดอนเมือง 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
#region ANUSORN SATHAN
#region TSB
item = new TSB();
item.NetworkId = "31";
item.TSBId = "319";
item.TSBNameEN = "ANUSORN SATHAN";
item.TSBNameTH = "อนุสรน์สถาน";
item.Active = false;
if (!TSB.Exists(item))
{
TSB.Save(item);
}
#endregion
#region PlazaGroup ANUSORN SATHAN
plazaGroup = new PlazaGroup()
{
PlazaGroupId = "AS",
PlazaGroupNameEN = "ANUSORN SATHAN",
PlazaGroupNameTH = "อนุสรน์สถาน",
Direction = "?",
TSBId = item.TSBId
};
if (!PlazaGroup.Exists(plazaGroup))
{
PlazaGroup.Save(plazaGroup);
}
#region Plaza ANUSORN SATHAN 1
plaza = new Plaza()
{
PlazaId = "3115",
PlazaNameEN = "ANUSORN SATHAN 1",
PlazaNameTH = "อนุสรน์สถาน 1",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#region Plaza ANUSORN SATHAN 2
plaza = new Plaza()
{
PlazaId = "3116",
PlazaNameEN = "ANUSORN SATHAN 2",
PlazaNameTH = "อนุสรน์สถาน 2",
TSBId = item.TSBId,
PlazaGroupId = plazaGroup.PlazaGroupId
};
if (!Plaza.Exists(plaza))
{
Plaza.Save(plaza);
}
#region Lanes (no data)
#endregion
#endregion
#endregion
#endregion
}
/// <summary>
/// Save entry button
/// Validate and save entry, force update on history
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SaveEntry(object sender, RoutedEventArgs e)
{
Entry ob = new Entry();
string msg = "";
ob.Date = Misc.ValidDate(txtDate.Text);
ob.EntryType = EntryType;
ob.Time = ValidNumber(txtTime.Text);
// Validate data
if (ob.Date <= 0)
{
msg = "Invalid date.";
}
else if (EntryType < 1 || EntryType > 4)
{
msg = "Select an entry type.";
}
else if (ob.Time < 0 || ob.Time > 2400)
{
msg = "Time must be between 0 and 2400 (military time).";
}
if (msg.Length > 0)
{
MessageBox.Show(msg);
return;
}
// Set the rest of it
ob.Glucose = ValidNumber(txtGlucose.Text);
ob.BaseDose = ValidNumber(txtBaseDosage.Text);
ob.GlucoseAdj = ValidNumber(txtGlucoseAdjustment.Text);
ob.FastActingDose = ValidNumber(txtTotalDose.Text);
ob.SlowActingDose = ValidNumber(txtSlowDose.Text);
ob.CarbGrams = ValidNumber(txtCarbs.Text);
ob.FoodDesc = GetRichText(txtFoodEaten);
ob.Notes = GetRichText(txtNotes);
Db.SaveEntry(ob);
EntryDateUpdated(sender, e);
// Show a popup if the entry is for current day, to show
// value against week/two-week/and month averages
if (ob.Date == Misc.DateAsInt())
{
var week = Db.GetHistory(7);
var month = Db.GetHistory(30);
var two = Db.GetHistory(14);
int weekDiff = ob.Glucose - getHist(EntryType, week);
int twoDiff = ob.Glucose - getHist(EntryType, two);
int monthDiff = ob.Glucose - getHist(EntryType, month);
MessageBox.Show("Today's Value: " + ob.Glucose +
"\nVs week: " + weekDiff + " (" + getHist(EntryType, week) +
")\nVs two-week: " + twoDiff + " (" + getHist(EntryType, two) +
")\nVs month: " + monthDiff + " (" + getHist(EntryType, month) +
")\n");
}
}
//自己特有的方法
/// <summary>
/// 查找到用户
/// </summary>
/// <param name="userName"></param>
/// <param name="userPwd"></param>
/// <returns></returns>
public UserInfo GetUserInfo(string userName, string userPwd)
{
return(Db.Set <UserInfo>().Where(u => u.UserName == userName && u.UserPwd == userPwd).SingleOrDefault());
}
public static void Add(ProfileInfo o, string user)
{
Db.ProfileInfos.Add(o);
Db.SaveChanges(user);
}
public void RefreshList()
{
CompanyList recentInvoices = (CompanyList)RecentInvoices;
recentInvoices.Companies = Db.SQL("SELECT i FROM Company i");
}
public ActionResult EditProduct(ProductVM model, HttpPostedFileBase file)
{
// Get product id
int id = model.Id;
// Populate categories select list and gallery images
using (Db db = new Db())
{
model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
}
model.GalleryImages = Directory.EnumerateFiles(Server.MapPath("~/Images/Uploads/Products/" + id + "/Gallery/Thumbs"))
.Select(fn => Path.GetFileName(fn));
// Check model state
if (!ModelState.IsValid)
{
return(View(model));
}
// Make sure product name i unique
using (Db db = new Db())
{
if (db.Products.Where(x => x.Id != id).Any(x => x.Name == model.Name))
{
ModelState.AddModelError("", "That product name is taken!");
return(View(model));
}
}
// Update product
using (Db db = new Db())
{
ProductDTO dto = db.Products.Find(id);
dto.Name = model.Name;
dto.Slug = model.Name.Replace(" ", "-").ToLower();
dto.Description = model.Description;
dto.Price = model.Price;
dto.CategoryId = model.CategoryId;
dto.ImageName = model.ImageName;
CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId);
dto.CategoryName = catDTO.Name;
db.SaveChanges();
}
// Set TempData message
TempData["SM"] = "You have edited the product!";
#region Image Upload
// Chech for file upload
if (file != null && file.ContentLength > 0)
{
// Get extension
string ext = file.ContentType.ToLower();
// Verify extension
if (ext != "image/jpg" &&
ext != "image/jpeg" &&
ext != "image/pjpeg" &&
ext != "image/gif" &&
ext != "image/x-png" &&
ext != "image/png")
{
using (Db db = new Db())
{
ModelState.AddModelError("", "The image was not uploaded - wrong image extension.");
return(View(model));
}
}
// Set upload directory paths
var originalDirectory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\")));
var pathString1 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString());
var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Thumbs");
// Delete file from directory
DirectoryInfo di1 = new DirectoryInfo(pathString1);
DirectoryInfo di2 = new DirectoryInfo(pathString2);
foreach (FileInfo file2 in di1.GetFiles())
{
file2.Delete();
}
foreach (FileInfo file3 in di2.GetFiles())
{
file3.Delete();
}
// Save image name
string imageName = file.FileName;
using (Db db = new Db())
{
ProductDTO dto = db.Products.Find(id);
dto.ImageName = imageName;
db.SaveChanges();
}
// Save original and thumb images
var path = string.Format("{0}\\{1}", pathString1, imageName);
var path2 = string.Format("{0}\\{1}", pathString2, imageName);
file.SaveAs(path);
WebImage img = new WebImage(file.InputStream);
img.Resize(200, 200);
img.Save(path2);
}
#endregion
// Redirect
return(RedirectToAction("EditProduct"));
}
